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
