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
" 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  [Sybase][ODBC Driver]Unable to connect to database server: unable to start database engine
ERROR  [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Jason Hinsperger 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.