Appserver to Database connection

T

tekstylez

New Member
Question(s)...

I have the webclient connecting to the appserver correct, now I'm just having problems trying to figure out the connection from the appserver to the database. The database is setup on another server. Is this a connection I have to setup in the Progress Explorer? Or will I have to use a connect statement in one of my appserver programs to connect to the database?
 
On the AppServer 'Server Startup Params' option connect to your remote DB using:

-db <yourdb> -H <hostname> -N TCP -S <servicename>
 
Just to make sure, in the Progress explorer, I went into the properties of my AppServer broker and entered the parameters under the Advanced Features part of the Server. Correct so far? If so, it says "for startup procedure". does this mean I need something in the Startup Procedure to run these parameters? If so, I'm not sure what I need there. Sorry, I couldn't find much documentation on this which is why I'm asking here.

Thanks for the help!
 
To enter the DB connection via Explorer.

1. Access the properties of the Appserver in question.
2. Expand the 'Server' item
3. Click on the 'General' option
4. Enter the DB connection info into the 'Server Startup Parameters' field.

Later,
Gordon
 
oh, I was looking in the wrong spot then, just tried it and it worked fine. Thanks gordon for all the help. One final question though, can I connect to multiple databases?
 
Yep.

same idea but use the following as an example.

-db db1 -H hostname -N TCP -S service1 -db db2 -H hostname -N TCP -S service2
 
You must log in or register to reply here.
Back
Top