Hello, I have a old myDemo.db file, that was created from Sybase 5.0. I need to create a Windows app to access that DB, I have tried all possibles connections strings (using ODBC), but none worked.

I have installed the Sybase 5.0 server and client app, I created the server locally(by service manager) and I can access by ISQL, but when I try to access from a .net windows app, doesn't work.

Recently, I installed the Sybase latest version, but when I try to create the myDemo.db, using the Personal Server app, doesn't work. "myDemo.db was created by a different version of the software".

Can someone help ? What do I need to use to create the ODBC and connect to that database? Thanks

The error that I get, when trying to use ODBC:

ERROR [08001] [Sybase][ODBC Driver]Unable to connect to database server
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

Code

string conStr = "Driver={Sybase SQL Anywhere 5.0};Dsn=Prima;uid=dba;PWD=test";
OdbcConnection conn = new OdbcConnection(conStr);
conn.Open();

string sql = "select count(*) from ClienteCorretor";
OdbcCommand cmd = new OdbcCommand(sql, conn);
int result = cmd.ExecuteNonQuery();

if (conn.State != ConnectionState.Closed)
    conn.Close();