title: ConnectionTimeout not working
body: <p>I try to build a database failover (ASP classic) but I have problem with the setting: ConnectionTimeout.
  I set it to 1 second but still the server try to connect to the first connection for more then 20 second.
  I like the connection will be lost after 1 second so I can transfer the user to the second connection right a way.</p>
  
  <p>Thanks,</p>
  
  <pre><code>&lt;%
  DSN             = "Provider=SQLOLEDB; Data Source=62.62.62.62; Initial Catalog=150109;User Id=noa; Password=tfdh545h54h;"
  DSN1                = "Provider=SQLOLEDB; Data Source=127.0.0.1; Initial Catalog=150109;User Id=noa; Password=tfdh545h54h;"
  
  Set conn            = Server.CreateObject("ADODB.Connection")
  conn.ConnectionTimeout = 1
  conn.CommandTimeout = 1
  Set rs              = Server.CreateObject("ADODB.RecordSet")
  On Error Resume Next
      conn.Open DSN
      If Err.Number &lt;&gt; 0 Then
          conn.Open DSN1
      End If
  On Error Goto 0
  '--
  
  sql ="SELECT TOP 10 *"
  sql = sql &amp; " FROM allDB"
  rs.Open sql, conn
  if (not rs.eof) and (not rs.bof) then
      groupARRAY = rs.GetRows
  end if
  rs.Close
  
  '--
  conn.Close
  Set rs          = Nothing
  Set conn        = Nothing
  %&gt;
  </code></pre>