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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"tamarindm" <ta*******@yahoo.com.sgwrote in message
news:11*********************@y66g2000hsf.googlegro ups.com...

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

[Rad [Visual C# MVP]]

On 22 Mar 2007 02:48:30 -0700, tamarindm wrote:

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?

--
Bits.Bytes
http://bytes.thinkersroom.com

[PS]

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

"tamarindm" <ta*******@yahoo.com.sgwrote in message
news:11*********************@y66g2000hsf.googlegro ups.com...

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

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