Dbi Timeout expired Sql server 2005 using ADO

Discussion in 'Ruby' started by Pablo Q., Sep 18, 2008.

  1. Pablo Q.

    Pablo Q. Guest

    [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.
    Pablo Q., Sep 18, 2008
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Shahab Gerami

    ado.net Timeout expired

    Shahab Gerami, Jul 3, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    440
    Shahab Gerami
    Jul 3, 2003
  2. Bob Johnson
    Replies:
    0
    Views:
    3,755
    Bob Johnson
    Aug 7, 2003
  3. Nils Magnus Englund

    "Timeout expired" for simple ADO.NET SQL Server query

    Nils Magnus Englund, Sep 12, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    16,748
    Kevin Spencer
    Sep 12, 2005
  4. Nils Magnus Englund
    Replies:
    0
    Views:
    770
    Nils Magnus Englund
    Sep 15, 2005
  5. David Morgan

    ASP + SQL Server - Timeout Expired

    David Morgan, Oct 1, 2003, in forum: ASP General
    Replies:
    1
    Views:
    162
    Bob Barrows
    Oct 1, 2003
Loading...

Share This Page