Home Forums SQL Server 2005 T-SQL (SS2K5) what is the difference between ODBC and OleDB? RE: what is the difference between ODBC and OleDB?
Steve Jones - SSC Editor
SSC Guru
Points: 734314
More actions
July 28, 2008 at 9:50 am
#849256
Good explanation. OLEDB is newer and superceeds ODBC. You should aim to use OLEDB connections where possible. I believe there's an OLEDB provider that encapsulates all ODBC functionality.