# Dbi Timeout expired Sql server 2005 using ADO

**URL:** <https://www.ruby-forum.com/t/dbi-timeout-expired-sql-server-2005-using-ado/148943>\
**Category:** Ruby\
**Created:** [September 18, 2008, 3:10pm UTC](https://www.ruby-forum.com/t/dbi-timeout-expired-sql-server-2005-using-ado/148943 "2008-09-18T15:10:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pabloq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/ec9cab/32.png) [@pabloq](https://www.ruby-forum.com/u/pabloq)\
**Post date:** [September 18, 2008, 3:10pm UTC](https://www.ruby-forum.com/t/dbi-timeout-expired-sql-server-2005-using-ado/148943/1 "2008-09-18T15:10:38Z")

</div>

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