Unix Technical Forum

SEO

vBulletin Search Engine Optimization


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces odbc

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 04:27 PM
Jack Wilson
 
Posts: n/a
Default How to determine if Use Declare/Fetch is in use by looking at CX= values inconnection string

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;B 0=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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 06:45 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145