[dba-SQLServer]ODBC Connection

Two new UDFs for the dbaLibrary :-)
BOD() beginning of debate
EOD() end of debate

Arthur

-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Jim Lawrence
(AccessD)
Sent: February 11, 2003 6:24 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]ODBC Connection

Hi Julie:

An ODBC connection may seem like a simple method to get connected to a SQL
database. There is a price to pay and that is in performance. At one time
when I was still debating whether to use an ODBC connection or go directly
to ADO-OLE. A simple test set the course. The result was as follows: ODBC
downloading 10,000Plus records a report, 20 minutes...ADO-OLE 1.3 seconds.
End of debate.