Postgres Pro
Downloads
Home   >   mailing lists

Connect Timeout Does Not Work - Mailing list pgsql-odbc

From Frankie Lam
Subject Connect Timeout Does Not Work
Date
Msg-id 001901c3317b$6f5362a0$6501a8c0@rnd.ucr.com.hk
Whole thread Raw
List pgsql-odbc
Tree view
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

pgsql-odbc by date:

Previous
From: Chris Gamache
Date:
Subject: Re: VB Resync
Next
From: Andreas Pflug
Date:
Subject: Unicode/client_encoding/conversion problem