Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need to connect to Sybase SQL Anywhere database 5.0 through asp.net

I am trying to connect to SQL anywhere 5.0  using below connection string 

 

sConnString =

" Driver=Sybase SQL Anywhere 5.0;Uid=dba;Pwd=sql;EngineName=Tenmax;DatabaseName=Tenmax;Start=c:\sqlany50\win32\dbclient.exe;DatabaseSwitches=-commandSwitch1 -commandSwitch2;DatabaseFile=E:\Applications\VinayNandaLIL\Tenmax.db;AutoStop=NO;"

It is giving below error

ERROR [08001] [Sybase][ODBC Driver]Unable to connect to database server: unable to start database engine

ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

Please guide.

Tags:
Former Member
replied

The problem you are most likely having is that the application is trying to use the ODBC SDK version 3.5, but the SQL Anywhere version 5 ODBC driver only supported ODBC SDK version 2.x (or maybe 3.0).

There is no way around this unless you have a more recent version of SQL Anywhere that you can use to access (and rebuild) the database.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question