OLEDB vs. ODBC Database Drivers

[pcorreia]

Does anyone have any experience relating to performance benefits/drawbacks of using the OLEDB driver for SQL Server over the ODBC driver?

Common sense tells me that the OLEDB driver should be faster, since ODBC on SQL Server is really just a wrapper for OLEDB anyway, but we've always used ODBC in my shop and I don't know if there's any advantage one way or the other.

 

[SidianConsulting]

Check out this thread:

thread232-306443

In my post in that thread there is a link to another thread with even more feedback on this subject. The bottom line is, I've stuck with ODBC with SQL Server through CF 5.0, but am now using the native drivers in CFMX w/SQL Server.

HTH,

-Tek

 

[SidianConsulting]

One more thing, if you are using CFMX then there is some info here for setting up the JDBC SQL Server driver in the CFMX Administrator, if you need it:

thread232-336859

-Tek