Sharing an ASA .db through a PB App

[connoq]

This is more of an Adaptive Server Anywhere question, but figured I’d float it over here as well…

We have an application that, in it’s initial development, was intended to be stand-alone. The application, runtime DLL’s, rteng7.exe, and the database file all exist on the PC running the application. Our platform is PowerBuilder 8 and Adaptive Server Anywhere 7.

We now have a need to share the database file. We moved the .db to a shared directory on the network and, through ODBC, pointed each system DSN to the .db on the network (with a lock level of RU). With this configuration, only 1 person can use the .db at a time. With one person logged in to the database file, each additional user gets an error message that the database is invalid.

Any thoughts on how we can make the .db available to more than one user at a time? Will we have to install ASA on our server?

Thanks!

 

[BennyYacaco]

connoq,

If you moved your db to a shared directory, I presume you copied it to a server. With that, you have ASA running in that machine. You might want to re-install the ASA. Upon the installation of ASA, there is one part there that asks you for the number of user connections, just specify how many users there are that needs to connect to the database.

HTH,

Benny

 

[connoq]

Benny,

Thanks! We'll give it a try.

Connoq.