Reason I was thinking that was because of the old MDAC memory leak... We restart the services at around 3am to circumvent that memory leak. You know, the on Microsoft says isn't their fault and Macromedia says it's Microsoft's fault...
Anyway, I found that the crash I was experiencing also had people saying it's mdac related... Definitely not a database issue. It's been running great forever. But anyway, I found the same thing... -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 4:25 PM To: CF-Talk Subject: RE: Switching to OLE DB You'll find people on both sides of the fence with this one. In all the research I've done it looks like ODBC seems to be the better choice. I've heard that OLE can be buggier than ODBC and many of the performance improvements that some people attribute to OLE are just myth. Anyhow, I HIGHLY doubt that switching will make any difference one way or another. Maybe your problem is DB related - maybe not - but it almost certainly is not related to your choice of ODBC or OLE drivers. +-----------------------------------------------+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -----Original Message----- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 4:18 PM To: CF-Talk Subject: RE: Switching to OLE DB Hmmm... I probably should have checked the archives first <:-) -----Original Message----- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:53 PM To: CF-Talk Subject: Re: Switching to OLE DB Well, I don't know if it's that clear cut, but I initially switched to oledb, thinking that it was the *way to go*, because it was more "native" and faster than odbc. When I posted my problems, the few cftalkers that responded said that oledb was probably *not* the way to go. :-/ Hopefully, others will chime in, and have *all* the answers. Jamie On Wed, 18 Jun 2003 13:24:58 -0700, in cf-talk you wrote: >Hmm... So oledb no work... That sux... > >-----Original Message----- >From: Jamie Jackson [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 18, 2003 12:57 PM >To: CF-Talk >Subject: Re: Switching to OLE DB > > >[whoops, newsgroup users, i posted to only the newsgroup the first >time] > >When I tried OLEDB, I had a couple of problems. > >One, a query would fail for some mysterious reason (a connection >problem) one in, maybe 1000 queries, but I could never get it to fail >myself, nor could I nail down why it was happening. I went back to >ODBC, and it never happened again. Someone else confirmed similar >problems. > >Two, (my memory's foggier on this one) I could not retrieve more than >one text field per query... terribly annoying when > 1 were needed. > >Jamie > >On Wed, 18 Jun 2003 12:21:29 -0700, in cf-talk you wrote: > >>Please, help... Our ColdFusion 5 services have been crashing and >>restarting lately, and I've been thinking of converting to OLEDB >>drivers instead of ODBC to see if the memory leak is related to the >>use of ODBC alone. It's not much, but it'll help I'm sure. >> >>So naturally, I piced the SQLOLEDB drivers first. Those are great. I >>get this error: "Unknown Data Access Error." every time I try to >>envoke a stored procedure. Pretty uninformative. I've found little >>information on this, and those who had the problem never got an >>answer... >> >>Fine. I figured let's try using MSDASQL instead... Not the best to >>use an OLEDB to ODBC bridge, but still, at least it's not just ODBC. >>I am particularly trying to find the source of the memory leaks. So >>with MSDASQL, I get an error message on stored procedures with output >>variabls: "Miltiple-Step OLE DB operation generated errors. Check >>each >>OLE DB status value, if available. No work was done." >> >>I found this article on that: >>http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269495 >> >>Well, the key already exists for MSDASQL, so that kb article does >>nothing for me. >> >>I have tried with MDAC 2.6 and MDAC 2.7... >> >>Any thoughts on what to do next? >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
