How to Set Timeout for Ruby ODBC Driver for SQL Server?
- by Seth Ladd
Hello,
I would like to know how to explicitly set a timeout for the Ruby DBI ODBC driver, when connecting to SQL Server. I would like long running queries to simply timeout and cancel themselves, saving further server resources and Rails processes.
This was happening while we were using the ADO based Ruby driver, but now that we've switched to…