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

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.