Sybase SQL Anywhere 9 and Sybase SQL Anywhere 11

[Former Member]

Hello there,

I am experiencing a problem while working with a client/server architecture model using Sybase SQL Anywhere 9 and
Sybase SQL Anywhere 11. I have got a client (Sybase central client) installed on one server and a Sybase database server installed on the second server and a database file placed on the third server. It's a 3 tier architecture and all the servers are on the network where as the client uses tcp/ip communication protocol and ODBC driver to talk to the server. I am trying to access the file from the client and I couldn't make it work as I am getting "database not found" error (sql error -83) because the database file is not located on where the database server is running. Can someone please advise whether this architecture works in any version of Sybase SQL Anywhere? Note: I do know file corruption may occur if database server and database file are located on different servers. But still I want to make this architecture works.

It would be much appreciated if anyone has implemented this architecture.

Any information would be much appreciated.

Thanks & Regards

Ramesh

[former_member188493]

> if anyone has implemented this architecture.

You will not find anyone who has successfully used dbsrv11.exe on one computer to start a database.db file on a different computer... that's because . it . does . not . work . reliably.

You will find people to help with your "database not found" error, but first you have to tell us where the message is coming from:

dbsrv11.exe when you try to start the database.db file? Tip: the database.db file specificaton on the dbsrv11.exe command line must point to the other computer, perhaps using a UNC filespec.

dbsrv9.exe when you try to start the database.db file?

Sybase Central when you try to connect to a running database?