Re: ODBC Driver Options

Have a look here

http://www.flatmtn.com/computer/Linux-PostgreSQL.html

I think "use declare/fetch" is "FETCH"


'   PG_ODBC_PARAMETER           ACCESS_PARAMETER
'   *********************************************
'   READONLY                    A0
'   PROTOCOL                    A1
'   FAKEOIDINDEX                A2  'A2 must be 0 unless A3=1
'   SHOWOIDCOLUMN               A3
'   ROWVERSIONING               A4
'   SHOWSYSTEMTABLES            A5
'   CONNSETTINGS                A6  'must be a value, blank is A6=;
'   FETCH                       A7  'must be a value, try 100
'   SOCKET                      A8  'default 4096
'   UNKNOWNSIZES                A9  ' range [0-2]
'   MAXVARCHARSIZE              B0  'must be a value, default 254
'   MAXLONGVARCHARSIZE          B1
'   DEBUG                       B2
'   COMMLOG                     B3
'   OPTIMIZER                   B4  ' note that 1 = _cancel_ generic 
optimizer...
'   KSQO                        B5
'   USEDECLAREFETCH             B6
'   TEXTASLONGVARCHAR           B7
'   UNKNOWNSASLONGVARCHAR       B8
'   BOOLSASCHAR                 B9
'   INVERSEBOOL?                BI  '"true is -1"?, 0=checked?
'   PARSE                       C0
'   CANCELASFREESTMT            C1
'   EXTRASYSTABLEPREFIXES       C2  'must be a value, default dd_
 



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match