According to the Administration (5.0) Manual, the value for Jet (Access) is:
Microsoft.Jet.OLEDB.4.0
I'm told that OLEDB is much faster/stabler for Access databases than ODBC
is, though SQL Server users will see little or no improvement. (Beware of
date issues though; ODBC-formatted dates don't always work well through
OLEDB datasources-- or native drivers, for that matter.)
Daryl
----- Original Message -----
From: "Bakken, Kory" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 10:11 AM
Subject: [KCFusion] OLE DB
Can anybody help me with setting up an OLE DB Datasource for an Access
Database. The setup in the Coldfusion Administrator is requiring a
"Provider". I do not know what to put there, so the connection is failing.
I read that the OLE DB connection improves performance over ODBC, is this
accurate?
Kory Bakken
IT Enterprise Release Management - Tools Team
work 816.559.4801
pcs 816.305.5890
fax 816.559.4862
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]