11-14-14, 00:07 #1Registered User
- Join Date
- Nov 2014
Unanswered: Unable to connect to sybase; OLEDB Exception 'Cannot connect to the datasource'
I recently installed sybase on my development machine. I'm trying to connect to a sybase database using ADO.NET Oledb connection. The connection string I'm using is
"Provider=Sybase ASE OLE DB Provider;Server Name=XXXXXXX;Datasourcce=XXXXX;User ID=XXX;Password=XXXX;dsn=XXXXX"
I'm unable to connect to the database and I get an oledb exception that says 'unable to connect to the datasource'
Strange thing is, I'm able to connect to the same database using SqlDbx Database IDE.
Also I am able to test the connection to the same server using the Sybase ASE OLE DB administrator tool which is located under ...\Syb1200\OLEDB-2_1\sydaadm.exe
I've absolutely no idea what's missing in my machine. Could someone provide some help like what I might need to check.
Your help is greatly appreciated in this regard.
Thanks & regards,