Skip to Content
avatar image
Former Member

Sybase SQL Anywhere 9 and Sybase SQL Anywhere 11

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Nov 18, 2015 at 03:02 PM

    Wrong community.

    While there may be some folks in this community with SQL Anywhere experience/knowledge, you'll find a bigger SQL Anywhere audience over in the SAP SQL Anywhere community.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 19, 2015 at 01:25 PM

    > 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?

    Add comment
    10|10000 characters needed characters exceeded