How to determine if Use Declare/Fetch is in use by looking at CX= values in connection string

From: Jack Wilson <ljwilson(at)digitalav(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: How to determine if Use Declare/Fetch is in use by looking at CX= values in connection string
Date: 2008-04-15 18:12:04
Message-ID: OF924BB5EF.727C1F74-ON8525742C.005FC69D-8525742C.0063FBAE@digitalav.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I'm trying to reliably determine whether Use Declare/Fetch cursors
(Abbreviation: B6) is in use for a given DSN based on how my program sees
the connection string. Unfortunately the B6 value doesn't show--but it
appears if I could properly decode the CX= piece I can determine whether
Use Declare/Fetch is active.

Here is an example string returned by my app:
DSN=psql-mydsn;DATABASE=mydb;SERVER=localhost;PORT=5432;UID=postgres;PWD=mypassword;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1b543b8;A1=7.4-1

for the above dsn I set to use defaults, then just set the UseDeclare
Fetch in the system dsn.

Other examples for CX=
CX=1b503ba (all defaults--Use Declare/Fetch disabled by default)
CX=1b547ba (all defaults, but CommLog set to record)
CX=1b40b0 (all check boxes unchecked, except Use Declare/Fetch is
checked--note this example has one less hex character--I'm thinking maybe
a leading 0 is ignored, but not sure for which pair (1b, 40, or b0).

I looked at the source, but it would take me a while to decipher this--I
was hoping somebody might have a hint.

Thanks...jack

Browse pgsql-odbc by date

  From Date Subject
Next Message Michael Knigge 2008-04-16 11:38:57 How to force an Option?
Previous Message noreply 2008-04-15 15:51:57 [ psqlodbc-Bugs-1010377 ] GUID code missing in convert.c (&quot; Unrecognized C_parameter ..&quot; ) and fix