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