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:266038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4