[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 fax816.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]
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 fax816.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]
RE: [KCFusion] OLE DB
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 fax816.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]
RE: [KCFusion] OLE DB
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) in Access. Insert Into SampleTable (datefield, otherfield) values (getdate(), 'othertext') Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bakken, Kory Sent: Wednesday, September 05, 2001 1:55 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] OLE DB 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? __ 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]
