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
Click image for larger version. 

Name:	Untitled.jpg 
Views:	3 
Size:	80.2 KB 
ID:	15965

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,
Sunil Reddy