Is there an ADO.NET driver for Sybase ASE 12.5?

[John]

Hi,

I know how to talk to SQL Server from C#. I need to talk to Sybase
from C#. Do I have to buy a driver/provider, does it come from Sybase,
or do I have everything I need within the C# ADO.NET.

Thanks,
John

 

[William Ryan eMVP]

Can't you get in with either ODBC or Oledb?

 

[Kevin Yu [MSFT]]

Hi John,

Thank you for posting in the community!

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you want to know how to connect to a
Sybase database with ADO.NET. If there is any misunderstanding, please feel
free to let me know.

As far as I know, you needn't get a specific provider for a Sybase
database. OleDb provider and ODBC provider can be used to connect.
Generally when if you have installed the client side for the database, the
OleDb or ODBC drivers will be installed on you computer. Whether to use
OleDb or ODBC provider depends on the driver DBMS has provided. If both are
installed, it is recommended to use the OleDb provider to connect.

When connecting with OleDb provider, create an OleDb Connection in the
project and set the connection string property for the OleDbConnection. If
the OleDb driver is properly installed, you will see it in the Provider tab.

If you are connecting with ODBC provider, you have to create an ODBC
connection in the ODBC Data Source. Here are the steps:
1. Open Control Panel from the Start menu. Select Administrative Tools.
2. Open Data Source (ODBC).
3. In the System DSN tab, Click Add button.
4. If the ODBC driver for Sybase is properly installed, it will appear in
the drivers list.
5. Create an ODBC data source following the wizard.
6. Create an ODBCConnection object in VS.NET project and connect to the
ODBC data source you have just created.

Hope this helps.

Does this answer your question? If anything is unclear, please feel free to
reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Guest]

This is the only one I know of, haven't tried it though:

http://www.datadirect-technologies.com/products/dotnet/dotnetindex.asp

 

[Kevin Yu [MSFT]]

Hi John,

I'd like to know if this issue has been resolved. I'm still monitoring on
this. If there is any problem, please feel free to post them in the
community.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."