Adaptive Server Anywhere ODBC Driver connection strings

Connects to

Sybase Adaptive

  • Standard

    Driver=Adaptive Server Anywhere 7.0;ENG=server.database_name;UID=myUsername;
    PWD
    =myPassword;DBN=myDataBase;LINKS=TCPIP(HOST=serverNameOrAddress);
  • Specific port

    Driver=Adaptive Server Anywhere 7.0;ENG=server.database_name;UID=myUsername;
    PWD
    =myPassword;DBN=myDataBase;LINKS=TCPIP(HOST=serverNameOrAddress:1234);
  • Multiple servers

    Driver=Adaptive Server Anywhere 7.0;ENG=server.database_name;UID=myUsername;
    PWD
    =myPassword;DBN=myDataBase;LINKS=TCPIP(HOST=Server1,Server2);
  • Multiple servers with different TCP/IP ports

    Driver=Adaptive Server Anywhere 7.0;ENG=server.database_name;UID=myUsername;
    PWD
    =myPassword;DBN=myDataBase;LINKS=TCPIP(HOST=Server1:3322,Server2:7799);
Problems connecting?
Get answer in the Sybase Adaptive Q & A forum
ODBC DriverDriver=Adaptive Server Anywhere 7.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.