Sharing a .db?

[connoq]

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!

 

[onealm]

You need to install ASA Server on the server. Each workstation connecting to the database will need to use an ASA Client.

Putting the database in a shared folder is not necessary (and doesn't help anything) as the ASA Server provides all connectivity to the database. That's the way client-server architecture is supposed to work.