Sybase SQL Anywhere (former Watcom SQL) ODBC driver connection strings

Connects to

Sybase Adaptive

  • Default local database engine

    Driver={Sybase SQL Anywhere 5.0};DefaultDir=c:\dbfolder\;Dbf=c:\mydatabase.db;
    Uid
    =myUsername;Pwd=myPassword;Dsn="";

    The empty DSN parameter could be critical if experiencing error 7778.

    Remember to start the connection string with "odbc:" if you are using PHP PDO_ODBC

  • Database engine not running

    Driver={Sybase SQL Anywhere 5.0};Uid=myUsername;Pwd=myPassword;
    EngineName
    =myServerAddress;DatabaseName=myDataBase;
    Start
    =c:\sqlany50\win32\dbclient.exe;
    DatabaseSwitches
    =-commandSwitch1 -commandSwitch2;
    DatabaseFile
    =c:\pb\ex\psdemodb.db;AutoStop=NO;

    If AutoStop is set to YES then the database is unloaded automatically as soon as there are no more open connections to it.

    When the engine starts the database specified by DatabaseFile, the engine will use the supplied DatabaseSwitches as command line options to determine startup options for the database. The Sybase manual contains a List of DatabaseSwitch values.

Problems connecting?
Get answer in the Sybase Adaptive Q & A forum
ODBC DriverDriver=Sybase SQL Anywhere 5.0Info and driver downloads

Providers

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.