SQL Server timeout expired

Discussion in 'Ruby' started by sheng chen, Apr 27, 2011.

  1. sheng chen

    sheng chen Guest

    Hello,

    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.

    Here is my code -
    ...
    connection_string << "CommandTimeout=0"
    @connection = WIN32OLE.new('ADODB.Connection')
    @connection.ConnectionTimeout = '0'
    @connection.Open(connection_string)

    Please help! Thank you very much in advance!!!

    --
    Posted via http://www.ruby-forum.com/.
    sheng chen, Apr 27, 2011
    #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. Bob Johnson
    Replies:
    0
    Views:
    3,738
    Bob Johnson
    Aug 7, 2003
  2. 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,742
    Kevin Spencer
    Sep 12, 2005
  3. Nils Magnus Englund
    Replies:
    0
    Views:
    762
    Nils Magnus Englund
    Sep 15, 2005
  4. David Morgan

    ASP + SQL Server - Timeout Expired

    David Morgan, Oct 1, 2003, in forum: ASP General
    Replies:
    1
    Views:
    156
    Bob Barrows
    Oct 1, 2003
  5. Pablo Q.
    Replies:
    0
    Views:
    143
    Pablo Q.
    Sep 18, 2008
Loading...

Share This Page