| 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-13 07:14:29 |
| Message-ID: | 001901c3317b$6f5362a0$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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | javier garcia - CEBAS | 2003-06-13 11:59:50 | "No such attribute or function 'oid'" |
| Previous Message | Chris Gamache | 2003-06-12 21:32:58 | Re: VB Resync |