Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Ruby > SQL Server timeout expired

Reply
Thread Tools

SQL Server timeout expired

 
 
sheng chen
Guest
Posts: n/a
 
      04-27-2011
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/.

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Ersin Gençtürk ASP .Net 1 09-25-2007 07:33 AM
Urgent: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. VB Programmer ASP .Net 4 01-24-2006 04:48 AM
Re: "Timeout expired" for simple ADO.NET SQL Server query Nils Magnus Englund ASP .Net 0 09-15-2005 11:25 AM
"Timeout expired" for simple ADO.NET SQL Server query Nils Magnus Englund ASP .Net 3 09-12-2005 07:30 PM
Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Bob Johnson ASP .Net 0 08-07-2003 12:52 PM



Advertisments