From: gregarican <greg.kujawa@...>
Date: 2007-03-01T02:20:09+09:00
Subject: Re: DBI Timeout

On Feb 28, 10:17 am, "gregarican" <greg.kuj...@gmail.com> wrote:
> I am currently trying to retrieve a rather large recordset from a
> remote MS SQL Server. The recordset is retrieved using Ruby DBI. The
> recordset is roughly 120,000 rows. The Ruby script bombs out with an
> SQL timeout error. Is there a parameter I can use to extend the
> timeout value in the DBI library so that I can pull everything?

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 :-(