TCP/IP using ASAProv

Connection string

This Adaptive Server Anywhere OLE DB Provider connection string can be used for connections to Sybase Adaptive.

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.