OLEDB seems to be slightly faster under load, nothing much in it though
under normal conditions.

ODBC drivers can apparantly suffer from memory leaks under certain
circumstances. Although I've never really seen any evidence of this using
SQL server.

OLEDB handles dates and boolean fields slightly differently at times
(perhaps other data types too?), converting sites that use ODBC can be a
pain.

I've used both quite bit, and still don't have a preference. If I was trying
to decide which to use for a new site, then I would probably go with ODBC as
I know it better and find it easier.

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://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to