Classes (1)  /  ColdFusion (14)  /  ColdFusion Jobs (2)  /  General (6)  /  JQuery (7)  /  Quick and Dirty (3)  / 
Search Blog

 

Archives
RSS

 

 

 

Adobe Community Expert in ColdFusion

 

Adobe Ceritfied Instructor

 

CTT+ Certified Technical Trainer

 

Hosted By:

Alurium Hosting

Powered by BlogCFM v1.14

19 April 2012
Error Executing Database Query. [Macromedia][SQLServer JDBCDriver][SQLServer]Could not find prepared statement with handle 0
Simple solution to a weird problem

Here's a quick one. Yesterday I was trying to get a site up and running locally, lots of code in Coldspring. When I ran the site for the first time one of the queries errored out. I corrected the query and re ran and got the following error: Error Executing Database Query. [Macromedia][SQLServer JDBCDriver][SQLServer]Could not find prepared statement with handle 0

I went around and around with different blogs suggesting that it's a driver issue and various other things.. However I found a very simple solution:

Go into the ColdFusion Administrator and find the datasource for the query that's causing the error, open up the advanced settings and turn off "Maintain Connections Across Multiple Requests"and click the submit button. Immdiatly go back into the same datasource and turn this setting back on.

Problem Solved.

Posted by admin at 8:42 AM | Link | 0 comments

No comments found.

Commenting has been disabled for this entry.

 

© 2011 Scott Stewart / SSTWebworks
Design by Contented Designs