ODBC vs OLE - Performance?

[msc0tt]

I've written a VB6 app that makes a DSN-less connection to a SQL2000 DB. After much experimenting, I've got things to work with both ODBC and OLE methods (see below). Presently, the database is small but I would like to maximize efficiently for when it is huge. Is one of these methods a better choice over the other? Why?

ODBC method:
.ConnectionString = "Driver={SQL Server};" & _
"Server=172.16.1.7;" & _
"Address=172.16.1.7,1433;" & _
"Network=DBMSSOCN;" & _
"Database=" & sLocalDB & ";" & _
"Uid=" & sLocalUser & ";" & _
"Pwd=" & sLocalPass

OLE method:
.ConnectionString = "Provider=sqloledb;" & _
"Server=172.16.1.7,1433;" & _
"Network Library=DBMSSOCN;" & _
"Database=" & sLocalDB & ";" & _
"Uid=" & sLocalUser & ";" & _
"Pwd=" & sLocalPass

-with thanks
Mike

 

[ClayG]

Microsoft has always stated that OLE-DB is better for performance than ODBC. Just because ODBC is old technology now. Never seen it proven, but it seems everybody believes it.

 

[msc0tt]

Thanks ClayG. I too had seen reference that OLE was 'newer' but no mention that it was 'faster'. I guess in a Microsoft world, newer has got to be better (gosh, I hope this doesn't start a rant war....).
-cheers.

 

[mrdenny]

I have also heard that OLE was faster than ODBC. However I haven't ever seen anything that showes that it is faster.

Denny

--Anything is possible. All it takes is a little research. (Me)