Sybase ASA .NET provider vs. ODBC

[Evan Stone]

Has anyone here done any benchmarking with the iAnywhere.Data.AsaClient
provider versus using System.Data.Odbc (or Oledb for that matter)?

Initially I thought that the iAnywhere provider was going to be the
better way to go, but in learning that it's just a .NET dll layer
(iAnywhere.Data.AsaClient.dll) over a Win32 DLL (dbdata9.dll), I was
just wondering how much it would buy us.

<thinking_out_loud>
Additionally, it seems that if we want to use other databases (like
SQLServer, for instance), then our best bet for compatibility is to use
the ODBC provider (and use T-SQL).
</thinking_out_loud>

Does this all sound reasonable, or am I way off base here?

Thanks!

-Evan

 

[Cowboy \(Gregory A. Beamer\) [MVP]]

If you can do all of your database work in OLEDB, I would use it over ODBC,
as ODBC is slower (lots of reasons, not enough time).

I have not tried the Sybase provider, but much of the data access, outside
of SQL Server will ultimately end up with some Interop somewhere down the
line. How they actually make the connect is important. If the driver is the
only COM, you might not have a serious problem. If they simply wrapped their
entire stack, you might.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************

 

[Evan Stone]

If you can do all of your database work in OLEDB, I would use it over ODBC,

as ODBC is slower (lots of reasons, not enough time).

Very interesting. I expected the opposite, but then again I haven't been
working with the .NET data stuff that long.

I have not tried the Sybase provider, but much of the data access, outside
of SQL Server will ultimately end up with some Interop somewhere down the
line. How they actually make the connect is important. If the driver is the
only COM, you might not have a serious problem. If they simply wrapped their
entire stack, you might.

Thanks for the recommendations & advice, Gregory! It gives us some good
points to consider.

-Evan