From: "Pablo Q." <paqs140482@...>
Date: 2008-09-18T22:02:36+09:00
Subject: Dbi Timeout expired Sql server 2005 using ADO

------=_Part_22008_25293494.1221743413494
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,

I got this error:

Execute OLE error code:80040E31 in Microsoft OLE DB Provider for SQL Server
Timeout expired HRESULT error code:0x80020009 Exception occurred.
c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:135:in `execute'

This is my connection string:

DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data Source=localhost;Initial
Catalog=xxxxxx;User Id=xxxxxx;Password=xxxxxx;Connect Timeout=0;")

Does anyone has solved this issue, I'm working with huge tables so,
sometimes an single query takes more than 5 minutes running...


Thanks

-- 
Pablo Q.

------=_Part_22008_25293494.1221743413494--