Connect to Sybase db VB2010 ADO

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);"
0
edit delete
are you sure?
asked Steve Julian

2 answers

Link to instructions that worked for me

0
edit delete
are you sure?
answered Steve Julian

You can use this Sybase ODBC driver and this connection strings instruction for correct tunning.

0
edit delete
are you sure?
answered Dan Wake

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions