Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 21, 2014 at 01:18 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jeff Albion

      Hello Jeff

      I am not able to unload data from dbunload. But i am able to convert the database to .csv file. Now is there any possibility to schedule job in the SQL any database editor  ,  so that daily automatically file will be generated to specified path.

  • Jul 21, 2014 at 12:13 PM

    Your command line is trying to connect to the SQL Anywhere version 5.0 client, and not a server directly.   Depending on what you are really trying to accomplish, you need to either:

    - start the database server on a separate machine, and then use the client to connect to it

    or

    - change your command line to connect to the database engine  (dbeng50.exe)

    You should know that version 5.0 is VERY old (for software).  It was released in 1996.   I would strongly recommend that you consider one of the newer versions.  You can download the version 16 Developer Edition here if you would like to try it out.

    Add comment
    10|10000 characters needed characters exceeded