George, We ran into the same problem a few months ago. What we found was the error was thrown on random queries that had CFQUERYPARAMs in them (which was almost every query in our application). Somewhere on the net I found an article explaining that it had something to do with the drivers. We switched our drivers to the jTDS JTDS drivers for MS SQL 2k and the problem went away.
HTH Rich Kroll > -----Original Message----- > From: George Abraham [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 09, 2007 8:38 AM > To: CF-Talk > Subject: SQL Server Error 8179: Could not find prepared statement with > handle x > > Hi all, > One of our CFMX 7 applications (which was working fine before) suddenly > started throwing this error - SQL Server Error 8179: Could not find > prepared > statement with handle x. The funny part is, it throws the error at pretty > much any point in the application without any apparent reason in the > sequence of code. If I comment out that code, then the some other query > code > will malfunction the same way with a different value for x. I looked > around > for solutions, but could not get any usable ones. One thing that worked > for > us is to increase the maximum number of pooled statements by 1 in the > datasource and then the problem went away. However it would be nice to > know > why the heck it happened in the first place. > > Thanks, > George > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
