Dbi Timeout expired Sql server 2005 using ADO

[Pablo Q.]

[Note: parts of this message were removed to make it a legal post.]

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:ADOrovider=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