The following is a reply I made to the CFGURU mailing list describing my experience with the "No more data available to read" error in CFMX server.




At least as of Macromedia drivers bundle version 3.3, the "No more data available to read" error is generated in SQL Server datasources when an existing connection in the connection pool isn't valid anymore. A request checks out an existing connection and attempts to use it, but if the connection isn't good anymore then this error is thrown and the connection is removed from the connection pool.

[More]