
ADO vs ODBC (SQL Server 7.0)
Hi
I have recommended to a colleague that using the native provider to connect
to a data source is faster than accessing the datasource using the OLE BD
provider for ODBC.
My colleague has always used ODBC connections and is asking what performance
improvement could be realised. I have no idea (although I am tempted to say
33% as there is one less layer in the process.). and am wondering if there
is anyone out there that could give me some sort of idea, maybe based on
experience. I am sure this is one of those "how long is a piece of string"
questions, however any comments would be welcome!
Regards
Vaughn