Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.ruby > #3571

SQL Server timeout expired

From sheng chen <sjchen@cambridgeassociates.com>
Newsgroups comp.lang.ruby
Subject SQL Server timeout expired
Date 2011-04-27 14:48 -0500
Organization Service de news de lacave.net
Message-ID <9320b0370edb078d04ce4c1f1574bfdb@ruby-forum.com> (permalink)

Show all headers | View raw


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/.

Back to comp.lang.ruby | Previous | Next | Find similar | Unroll thread


Thread

SQL Server timeout expired sheng chen <sjchen@cambridgeassociates.com> - 2011-04-27 14:48 -0500

csiph-web