Adaptive Server Anywhere OLE DB Provider connection strings

Connects to

Sybase Adaptive

  • Standard

    Provider=ASAProv;Data source=myASA;
  • TCP/IP

    Provider=ASAProv.90;Eng=server.database_name;Uid=myUsername;Pwd=myPassword;
    Links
    =tcpip(Host=servername);

    Use this when connecting to a server located on the other side of a router. Without the Links=tcpip(Host=servername) the error "Server could not be found" can arise when connecting.

Problems connecting?
Get answer in the Sybase Adaptive Q & A forum
OLE DB ProviderProvider=ASAProvInfo and provider 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.