2

I'm working on a .NET application to connect to an existing Sybase SQL anywhere database which is a .db file. Is it possible to connect it directly to the .db file just like how you would to an Access data file database or does it need a server to host the .db file just like MSSQL? If it is possible, how do I do it? Thank you very much :) I'm almost always using OLEDB.

Mike Gardner
  • 6,611
  • 5
  • 24
  • 34
chris_techno25
  • 2,401
  • 5
  • 20
  • 32

3 Answers3

3

The db file is not a normal readable file, and without the server installed, it can not be accessed.

The server is required to connect to the database, and to set up an client connections.

Mike Gardner
  • 6,611
  • 5
  • 24
  • 34
0

This should be what you're looking for http://www.sybase.com/detail?id=1054947

T.S.
  • 18,195
  • 11
  • 58
  • 78
  • Hi, thanks for your reply :) I actually read this before I posted my question. I tried the sample code without installing the Server software, just having the .db file. It always throws an exception that system is unable to start the server. This does mean that Sybase doesn't have the feature to connect to a database like Access right? – chris_techno25 Sep 27 '13 at 03:51
  • 1
    Oh well. Sybase is not your desktop database like MS Access. That I don't know. – T.S. Sep 27 '13 at 13:54
0

I found the answer. It's not possible to connect to the database without the server running. I tried it and it just doesn't work. It is possible to specify the location of the database provided you have Sybase server ready to run. Sybase will automatically run if you specify the location of the database. If Sybase server is not found, it should give you the error that says 'Server not found'. Thank you very much everyone :)

chris_techno25
  • 2,401
  • 5
  • 20
  • 32