[Macromedia][SQLServer JDBC Driver]Object has been closed.

I came across this very odd error today while trying to write a query in Coldfusion 9. I ensured the query worked in SQL Management Studio but each time I called the CFM page I was presented with the following error:

[Macromedia][SQLServer JDBC Driver]Object has been closed.

Having double checked everything, from my code to the set up of the server and DSN – everything looked perfectly as it should.

Finally, I stumbeled upon the solution: either resart the Coldfusion server or make a change to the DSN. I hope this helps saves others time as it took me forever to work this out.

Leave a Reply

Your email address will not be published. Required fields are marked *