| From: | "Frankie Lam" <frankielam(at)ucr(dot)com(dot)hk> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Connect Timeout Does Not Work |
| Date: | 2003-06-07 04:23:15 |
| Message-ID: | 000801c32cac$85129350$6501a8c0@rnd.ucr.com.hk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2003-06-09 08:40:33 | Re: [INTERFACES] cannot insert zero in to numeric field |
| Previous Message | Jeff Eckermann | 2003-06-06 23:47:19 | Re: [INTERFACES] cannot insert zero in to numeric field |