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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
