On Feb 28, 12:48 pm, khai... / enigo.com wrote: > On Thu, 1 Mar 2007, gregarican wrote: > > Specifically I am using the dbd_ado DBI library. Since the fetch_all > > method was timing out (the DB is alive and kicking; I've verified > > that) I tried while-looping a fetch method to append to the result > > array as an alternative. Either way the operation still times out :-( > > It sounds to me like the timeout is coming from the database. Do you have > a full stack trace for the exeption? > > Kirk Haines It is definitely coming from the database. Right now I'm trying to narrow down how to specify a CommandTimeOut parameter for the ADO conncection. My provider is SQLOLEDB. It's not specified in the connection string, I know that at least. But it's a property of the ADO connection itself. I know how to do this in VB, VBScript, C#, etc. but not using the Ruby DBI implementation.