CODEWITHSUNDEEP
database-connectionopenedgeappserver
Sheldon Humber
Sheldon Humber

Reputation: 17

How to connect databases on different serves?

I'm running into some trouble in OpenEdge on trying to connect a database on a test server to the database on the live server. I have opened a successful appserver connection using the following code:

connection-result = happsrv:connect ("-AppService "  +
               v-application_service + " -H "   +
               v-name_server_address + " -S "   +
               v-name_server_port ) no-error.

I'm trying to load data into the test database from the live database, so in order to do that, I need to connect to the the live database(I only have the appserver connection currently). I'm using the following command to try and connect to the live database:

connect value("-db /live/db/live.db -ld live").

However it can't find the live database. Any ideas on how to fix this, or of another way to do it? It has to be done with OpenEdge code, so none of the tools or anything.

Thanks

Upvotes: 0

Views: 1129

Answers (2)

Austin
Austin

Reputation: 1255

Before trying to connect as specified by Tim, you need to serve the database on "hostname".
For example:
proserve -H hostname -S portnumber

Please make this as a comment to Tim's answer. Sorry, but I don't have enough reputations

Upvotes: 0

Tim Kuehn
Tim Kuehn

Reputation: 3251

If the live server is on a different machine, then you need to use the client-server structure just like with the appserver:

   connect value("-db live.db -H hostname -S portnumber").

Upvotes: 0

Related Questions