[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.

HTH
Jim

-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Julie
Reardon-Taylor
Sent: Tuesday, February 11, 2003 9:26 AM
To: dba-SQLServer at databaseadvisors.com; accessd at databaseadvisors.com
Subject: [dba-SQLServer]ODBC Connection


I have an Access front-end using an odbc connection to sql tables.  The
connection is sometimes a bit slower than I would like.  Is there a better
way to connect to these tables than through odbc?



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net




_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com