From: khaines@...
Date: 2007-03-01T03:11:58+09:00
Subject: Re: DBI Timeout

On Thu, 1 Mar 2007, gregarican wrote:

> 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.

I've never used ADO, but, here's the connect method:


   def connect(dbname, user, auth, attr)
     # connect to database

     handle = WIN32OLE.new('ADODB.Connection')
     handle.Open(dbname)
     handle.BeginTrans()  # start new Transaction

     return Database.new(handle, attr)
   rescue RuntimeError => err
     raise DBI::DatabaseError.new(err.message)
   end


Unless I am badly understanding, you need to set a property on that handle 
that is returned, right?

The actual dbi handle that is ultimately returned has a handle() method on 
it which will return the lower level handle.  I'd check what methods you 
have available on it, but I would bet that once you are at that level, 
you'll see what you need to set the CommandTimeOut property on the handle.


Kirk Haines