Excel VBA connection to SQL Server using ADO
 

Hi there
I am using the ADO 2.7 Library to connect from an Excel workbook to a SQL
Server 2000 database over our local network. All works perfectly except,
when viewing the trace in SQL Profiler, I notice that, between each request
to the database, a connection object is destroyed and recreated, adding
significant overhead to our network requests. At first I though it was
because we were releasing the connection objects after each roundtrip to the
database, but still, when we use a single connection (opened at the outset
of the procedure and closed at the very end of the procedure), the "Audit
Login" and "Audit Logout" lines in SQL Profiler (with between 2000 and 6000
ms duration) continue. Do you have any suggestions about improving the speed
of execution?
Best regards
Taolo Morake