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