From: sheng chen Date: 2011-04-28T04:48:47+09:00 Subject: SQL Server timeout expired 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/.