VB-6.0 with sybase-11.0 connectivity..urgent

[giridharv77]

Hi friends!
please help me how can i connect Visualbasic-6.0 running on windowsNT to Sybase-11.0 running on linux server through ole-db provider as it is very urgent to our project.

[Serge]

There's no native OLEDB provider for Sybase database. If you have ODBC driver installed for Sybase System 11 then it is very easy to do it:


Dim cn As New ADODB.Connection
Dim strConn As String

strConn = "Driver={Sybase System 11};ServerName=MyServer;LogonID=MyLogon"
cn.Open strConn, , "MyPassword"

'Here do other stuff after you have connection opened.



That's it.