I am working in Visual Basic 2010 and connecting to a Sybase 12 database on a remote server using ADO.
I want to connect through code as the particular database will change.
I have not been able to find a connection string that works.
I can connect via ODBC using the ip address of the server and the database name, so I know the connection is possible if I can get the correct syntax for the connection string.
The last string I tried was
Dim strConnection As String = "Provider=ASAProv.12;ENG=192.00.00.00.rancustomreports;Uid=uid;Pwd=pwd;Links=tcpip(Host=192.00.00.00);"
Link to instructions that worked for me
You can use this Sybase ODBC driver and this connection strings instruction for correct tunning.