database connection from remote client

Posted by aaravindhantj on 07-May-2014 09:45

sir

pls assume that a database is start up and running in multi user mode in a remote server with all defined start up parameters. In remote client we set a bat file with all sort of  client connection parameters.

both the database and client are using open edge only.

my question is whether the remote client should start up the connected in single user mode or in multiuser mode to the database and if the the number of clients is around 50 then the each client will execute the connection bat file in his separate client  terminal and if this the scenario will the all 50 client will successfully connect to the server database which is started and running in  mutiuser mode.

thank you sir very much

All Replies

Posted by Paul Koufalis on 07-May-2014 09:56

There are a few questions here:

my question is whether the remote client should start up the connected in single user mode or in multiuser mode

The remote client CANNOT connect in single user mode.

if the the number of clients is around 50 then the each client will execute the connection bat file in his separate client  terminal 

Yes

if this the scenario will the all 50 client will successfully connect to the server database 


This depends on the server startup parameters -n -Mn -Mpb -Mi and -Ma.

Posted by gus on 07-May-2014 13:38

When the database is started and running in multi-user mode, then no single users connection (remote or local) are possible. Remote connections can only be made to a database that is running in multi-user mode. Single user database connections require exclusive access to the database and can be made only from the machine where the database resides.

Given the number of questions you have, perhaps you should procure a copy of the manuals. You can find it here community.progress.com/.../1329.openedge-product-documentation-overview.aspx

The Database Essentials book will probably be helpful.

This thread is closed