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?
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
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
We use the getdate() function in SQL Server to force a date on an INSERT
statement. It seems to work just fine for us and we haven't had a need
to use the CreateODBCDate() function. It uses the system clock to
create the date. I believe there is a similar getdate() function (or
the same one)