OleDbConnection to Sybase

  • Thread starter Thread starter tamarindm
  • Start date Start date
T

tamarindm

I am using the following to connect to a Sybase server.

OleDbConnection Conn= new OleDbConnection();
string connstr = "Provider=Sybase ASE OLE DB Provider;Data
Source=SERVER;User ID=USER;Password=password;database=DB";
Conn.Open();


I get the following error. What could be the problem ?


Multiple-step OLE DB operation generated errors


The same code can connect to MSSQL server with no problem just by
changing the connection string.


Thanks.
 
Have you checked the Errors property on the OleDbException instance that
was thrown? It should give you more information.

Hope this helps.
 
I am using the following to connect to a Sybase server.

OleDbConnection Conn= new OleDbConnection();
string connstr = "Provider=Sybase ASE OLE DB Provider;Data
Source=SERVER;User ID=USER;Password=password;database=DB";
Conn.Open();

I get the following error. What could be the problem ?

Multiple-step OLE DB operation generated errors

The same code can connect to MSSQL server with no problem just by
changing the connection string.

Thanks.
Click to expand...

Not sure that is the correct syntax for an ASE connection. What version of
ASE are you using?
 
Back
Top