I am trying to connect to a SQL Server 2005 database using the connection
parameters listed below. After connecting to the SQL Server 2005 database I
execute my sql statement. But I always timeout after approximately 60
seconds. I executed the sql statement within the query analyzer which takes
approximately 90 seconds to complete. Is there something I can add to my
connection parameters listed below so it will not timeout?

Thanks,


Set oConn = New Connection
With oConn

.ConnectionString = "Provider = SQLOLEDB;" & _
"Data Source = " & SOURCE_NAME & ";" & _
"Initial Catalog = " & DB_NAME & ";" & _
"Integrated Security = SSPI"
.ConnectionTimeout = 2000
.Open
End With