Pablo Q.
9/18/2008 1:03:00 PM
[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: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.