Thread: Connect Timeout Does Not Work
Hi all,
I've tried to set the Connect Timeout in DSN string and in VB6(ADO), but find it is not used at all.
My connection string is as follow:
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
Why? Has I made something wrong? Any pointers appreciated.
Regards,
Frankie Lam