sql server connect: I'm creating connection object to SQL Server db this way
Set objConn = New ADODB.Connection
objConn.CursorLocation = adUseClient
objConn.ConnectionString =
"PROVIDER=MSDASQL;dsn=Coordinator;uid=vladc;pwd=developer4444;database=SRS;"
objConn.ConnectionTimeout = 1
objConn.Open

It doesn't matter what value I'm setting to the ConnectionTimeout property.
If server is unavailable then it produces an error only after approximately
30 seconds. I read in MSDN than default ConnectionTimeout is 15 seconds. If
I comment assignment line in my code, it's still about 30 seconds.
So, for me ConnectionTimeout property doesn't work.
What am I doing wrong?
Thank you
Vlad

objConn.ConnectionTimeout = 30

--
Víctor Koch From Argentina.


"Vlad" <vovan.c@verizon.net> escribió en el mensaje
news:O$JZcAuWEHA.3664@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]

[quoted text, click to view]

Why use ODBC to connect to SQL Server? Why not use the native SQL OLE DB
provider?