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 log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions