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.
Printable View
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.
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:
That's it.Code: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.