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
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
.
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
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
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
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
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...
7 matches
Mail list logo