OleDbConnection to Sybase

[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.

 

[Nicholas Paldino [.NET/C# MVP]]

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

Hope this helps.

 

[Rad [Visual C# MVP]]

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.

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

 

[PS]

http://www.connectionstrings.com/?carrier=sybase

 

[tamarindm]

Thanks all for the replies.

I tried OleDbException but it displays the same error message. I am
using ASE 12.5. I tried each connection strings in
http://www.connectionstrings.com/?carrier=sybase it still didn't work.

But I changed to using OdbcConnection and it works fine. So I will
just use this instead of OleDb.