SQL Server Performance Forum – Threads Archive
ODBC vs. OleDBI have a web app (asp) that uses SQL server 2000. I would like to change it’s database access method to ODBC. What are the performance concerns/hits going from OleDB to ODBC?
OLEDB for SQL Server is more optimised than ODBC, I recommended upgrading (as you already intend to). The implications are that you should abandon your ODBC DSN if you use one, and OLEDB will require a connection string to the SQL Server.