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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ODBC or OLE DB
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. That layer introduces some performance loss, and also an extra point of failure. Jochem ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: ODBC or OLE DB
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
Re: ODBC or OLE DB
> 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. That layer introduces some performance loss, and also an extra > point of failure. OLE DB in combination with MSSQL produces extremely unhelpful error messages, at least this is what I experienced. I personally prefer decent error reporting over a bit of performance. Cheers Michiel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: ODBC 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 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 ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
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- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:28 To: CF-Talk Subject: RE: ODBC 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 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 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: ODBC or OLE DB
All my bit fields come back as 1/0 both in OLEDB and ODBC. All my date fields are treated the same. Text (VC, Text, etc.) fields, no probs. Numerics - all OK Anyone out there actually KNOW of any fundamental differences on the SQL interface level? > -Original Message- > From: Craig 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- > From: Steve Martin [mailto:[EMAIL PROTECTED]] > Sent: 11 December 2001 14:28 > To: CF-Talk > Subject: RE: ODBC 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 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 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
AS/400 Odbc or OLE DB Driver?? (Client Access unstable.)
Hello all, Does anyone know of a stable ODBC Or Ole Db driver to Connect to AS/400 from NT. We have already tried Client Access, huge memory leaks and NT crashes out. I dont think we can Use USB 6.1 or later cause we are not using DB2. Appretiate any thoughts Thanks Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.