Thread: Connect Timeout Does Not Work

Connect Timeout Does Not Work

From
"Frankie Lam"
Date:
Hi all,
 
I've tried to set the Connect Timeout in DSN string and use it in VB6(ADO), but find it is not used at all.
 
My connection string:
 
Provider=MSDASQL.1;Connect Timeout=5;Extended Properties="DRIVER={PostgreSQL};DATABASE=ucms;SERVER=192.168.1.50;PORT=5432;UID=postgres;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=set+client%5fencoding+to+%27SQL%5fASCII%27;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"
 
My ODBC Driver is V07.03.0100
 
Frankie Lam