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.