Thread: Documentation for PostgreSQL win32 ODBC-Driver 8.02.05.00 and connection strings
Documentation for PostgreSQL win32 ODBC-Driver 8.02.05.00 and connection strings
From
"Jochen Westland [invigo]"
Date:
Hi all,
we are currently quite unsucessfully looking for a documentation for the win32 odbc-driver, current version (8.02.05.00).
Is there a document describing all features, eg Extra Opts 0x10, etc.?
Additionally were looking for some help in understanding which option is set where in the options of a connection string like
strConn="ODBC;DRIVER={PostgreSQL};DATABASE=myDb;SERVER=192.1 68.0.91 ;" & _
"PORT=5432;UID=myDbUser;PWD=pass;A0=0;A1=7.4;A2=1;A3=0;A4=1; A5=0;A6=;A7=100;A8=4096;A9=0;"
& _"B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0 ;C1=0;C2=dd_"
"PORT=5432;UID=myDbUser;PWD=pass;A0=0;A1=7.4;A2=1;A3=0;A4=1; A5=0;A6=;A7=100;A8=4096;A9=0;"
& _"B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0 ;C1=0;C2=dd_"
well, some parts are quite obvious, like B1=8190, C2=dd_, we just cant find out, which parameter describes which option.
Can anyone help?
Best Regards
Jochen
Re: Documentation for PostgreSQL win32 ODBC-Driver 8.02.05.00 and connection strings
From
Richard Broersma Jr
Date:
--- On Fri, 12/7/07, Jochen Westland [invigo] <jochen.westland@invigo.de> wrote: > we are currently quite unsucessfully looking for a > documentation for the > win32 odbc-driver, current version (8.02.05.00). > > Is there a document describing all features, eg Extra Opts > 0x10, etc.? I agree, the documentation that comes with the ODBC driver could be more complete. Also it would be nice if the pgfoundrysite that hosts the odbc project would keep a link for current documentation that we all to refer to (much likethe PostgeSQL website has). Having said all of this, I did find out were to get the best information that is available. I used pgfoundy's CVS to downloadthe most current documents. It seems that CVS has documents that are not disrubted with the binaries. Unfortunity,is seems that they are not completely upto date with the features that the driver has. This link should mostly answer your question: it is from CVS: http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/docs/config-opt.html Here is where you can look for all other information: http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/docs/ Regards, Richard Broersma Jr.
Re: Documentation for PostgreSQL win32 ODBC-Driver 8.02.05.00 and connection strings
From
Richard Broersma Jr
Date:
--- On Fri, 12/7/07, Richard Broersma Jr <rabroersma@yahoo.com> wrote: > > Is there a document describing all features, eg Extra > Opts > > 0x10, etc.? This link describes a little more about what OPTS can take. However, I don't get what 0X10 could mean. Maybe it is somekind of hex value? Perhaps the options that you set are additive? http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/psqlodbc/docs/config.html?rev=1.8&content-type=text/html Regards, Richard Broersma Jr.
Hi all, I'm wondering if there are known issues with SQLCancel over psqlodbc in the last few versions, or specifically with 8.2.4? We've been having problems cancelling queries from several 3rd party tools - for example, clicking on cancel in microstrategy & BO won't do a thing. Therefore I'm wondering anybody else is experiencing such problems, maybe in specific configurations... Any information is appreciated! Thanks, Alon.