Hmm, we did have other problems with the current drivers we are using that was shipped with the product by (then) Macromedia. Mayve we can look at this driver you mention.
Thanks, George On 1/9/07, Richard Kroll <[EMAIL PROTECTED]> wrote: > > 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:266044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
