ODBC or OLE DB

2001-12-11 Thread Christopher Dawes
Hello CF-Talk, What's better/faster ODBC/OLE DB. I'm using SQL2k on Win2k. Kind Regards, Christopher Dawes Dawes International FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com

Re: ODBC or OLE DB

2001-12-11 Thread Jochem van Dieten
Christopher Dawes wrote: Hello CF-Talk, What's better/faster ODBC/OLE DB. I'm using SQL2k on Win2k. Better: ODBC from a portability point of view, OLE DB from a technical point of view (see faster). Faster: OLE DB. In this case (SQL2K) ODBC is actually a layer on top of OLE DB

RE: ODBC or OLE DB

2001-12-11 Thread Craig Dudley
. Craig. -Original Message- From: Christopher Dawes [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 13:36 To: CF-Talk Subject: ODBC or OLE DB Hello CF-Talk, What's better/faster ODBC/OLE DB. I'm using SQL2k on Win2k. Kind Regards, Christopher Dawes Dawes International FAQ: http

RE: ODBC or OLE DB

2001-12-11 Thread Steve Martin
I'm curious as to what differences you've found as I've used both interchangeably without any problems whatsoever. Could you possibly enumerate the differences for the benefit of the list. Cheers, Steve OLEDB handles dates and boolean fields slightly differently at times (perhaps other data

RE: ODBC or OLE DB

2001-12-11 Thread Craig Dudley
or OLE DB I'm curious as to what differences you've found as I've used both interchangeably without any problems whatsoever. Could you possibly enumerate the differences for the benefit of the list. Cheers, Steve OLEDB handles dates and boolean fields slightly differently at times (perhaps other

RE: ODBC or OLE DB

2001-12-11 Thread Steve Martin
Dudley [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:51 To: CF-Talk Subject: RE: ODBC or OLE DB The last problem I had was runnign query a query on a recordset returned via oledb, all the sql BIT fields were coming back as 'Yes' and 'No' as oppossed to 0/1. -Original Message

odbc to ole db driver between cold fusion, access

2000-04-03 Thread Nagai, Paul
Howdy, My question: Is anyone aware of a resource on the changes required for this conversion? I've noticed some queries supported by ODBC are not supported by OLE DB and some date formats are not supported. I'm hoping there aren't more conversion issues than those I've already discovered...