Daryl
If CreateODBCDate() and CreateODBCDateTime() don't always work, do you know
if there is an alternate function for OLE DB, or can you simply use the
generic CreateDate() and CreateTime() functions where those others were
previously required?
-----Original Message-----
From: Daryl Banttari [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 11:50 AM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] OLE DB
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]
______________________________________________________________________
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]