Sybase ASE ADO.net 2.0 provider?

Question

I'm looking for an ADO.net 2.0 or later provider for Sybase database which seems to be known as Sybase ASE. To clarify, I'm interested in ASE, and not SQL Anywhere. Hopefully the provider will be included with the database, or free.

I can find mention of an ADO.net 1.1 provider; that's not what I want.

I can find mention of ODBC drivers and OLEDB providers; that's not what I want.

I've found the DataDirect ADO.net providers which are paid for; I guess that's the fallback position.

Thanks for your help

Answer 1

This question is fairly old but it seems to have gotten easier to get the ADO Connector.

1. Download the "Get a Free "Developer" Edition" from http://scn.sap.com/community/developer-center/oltp-db
2. Choose Custom Install when given the option.
3. Only install the .Net ADO package from the custom install.
4. Reference the Sybase.AdoNet4.AseClient.dll in your solution from where the install put the files.

You should then be able perform queries, updates etc. in .NET by following the directions from here: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sdk_12.5.1.adonet/html/adonet/DAFJEFIF.htm