Connecting to sybase db version 6 and version 9

[Former Member]

hi all

i have some production databases on clients running on version 6 and version 9.

i want to develop some query interfaces with C#.

please note that my knoledge of sydbase is very very little.

i have downloaded and installed the "Sql Anywhere" (SA1201_Client.exe) from the sybase site on my laptop.

before i started to do anything i tryed the connection with the client tools : - Interactive SQL (64-bit) - Sybase Central (64-bit)

both complain that : "you are attempting to connect to a version 6/9 database running on a version 6/9 server on another database, you have to disconnect the running DB and connect to a version 10 or higher db...."

how can i connect to older version of the databases? what client software should i use?

thks in advanced

rgds rui

[MarkCulp · Accepted solution]

Version 12 of Sybase Central and dbisql (java version) do not support older (pre 10) versions of the server/databases... but the client libraries do. I.e. you can connect to a version 6-9 server using v12 client.

You have a few options:

• use v12 dbisqlc - this tool can connect to an older version of the server
• upgrade you databases to v12 and then use the v12 tools
• skip the tools and just write your app (could be risky since you say that you are not that familiar with SA).

[Former Member · Accepted solution]

hi mark

outstanding, just gave a shot at dbisqlc and works perfectly.

ill move right to development.

thank you and happy holidays.

rgds rui