Poor ODBC hangs Pike/Roxen

Imported from http://bugzilla.roxen.com/bugzilla/show_bug.cgi?id=1607

Reported by Toyotomi Hideyoshi, roxen@asylos.org

I use an ODBC driver in Windows that is not very good. When you write certain malformed SQL statements, the driver will not respond.

I am currently running Coldfusion/IIS and Roxen side by side in evaluation.

I am reporting this as a bug, when perhaps it's more of a feature request. With the above-mentioned ODBC driver web code with certain SQL errors will result in the page request endlessly waiting. Coldfusion and Roxen both exhibit this behaviour. It is fully expected.

However, when you stop trying to load the page Coldfusion will be able to continue processing other pages (or the same page after you fix your SQL errors). Roxen on the other hand will not respond to any further requests. It is still tripping on the ODBC driver I assume. Perhaps a threading issue.