ADO vs ODBC (SQL Server 7.0) 
Author Message
 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



Mon, 10 Mar 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

2. VB Sql Server Via ADO Problem: [Microsoft][ODBC Sql Server Driver]

3. VB 3.0 + SQL Server 7.0 + ODBC

4. VB6.0 ODBC Error 3027 SQL Server 7.0

5. ado connection to SQL Server 7.0

6. SQL Server 7.0 , ADO & VB 6.0

7. Problem refreshing SQL Server 7.0 joins in ADO

8. Need to Save .rpt files in SQL Server 7.0 with ADO 2.1

9. ado SP problem in SQL Server 7.0 and 2000

10. SQL Server 7.0 and ADO Cursors

11. Ado Save & Open with SQL server 7.0

12. ADO and SQL Server 7.0

 

 
Powered by phpBB® Forum Software