Documentation for PostgreSQL win32 ODBC-Driver 8.02.05.00 and connection strings

This is a multi-part message in MIME format.

------=_NextPart_000_001B_01C838DB.AE987740
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi all,
we are currently quite unsucessfully looking for a documentation for the
win32 odbc-driver, current version (8.02.05.00).
=20
Is there a document describing all features, eg Extra Opts 0x10, etc.?
=20
Additionally were looking for some help in understanding which option is =
set
where in the options of a connection string like=20
=20
strConn=3D"ODBC;DRIVER=3D{PostgreSQL};DATABASE=3DmyDb;SERVER =3D192.1 =
68.0.91 ;" & _
"PORT=3D5432;UID=3DmyDbUser;PWD=3Dpass;A0=3D0;A1=3D7.4;A2=3D 1;A3=3D0;A4=3D=
1;
A5=3D0;A6=3D;A7=3D100;A8=3D4096;A9=3D0;"
& =
_"B0=3D254;B1=3D8190;B2=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3 D1;B8=3D0;B9=3D=
1;C0=3D0
;C1=3D0;C2=3Ddd_"
=20
well, some parts are quite obvious, like B1=3D8190, C2=3Ddd_, we just =
cant find
out, which parameter describes which option.=20

Can anyone help?

=20

Best Regards

=20

Jochen

=20

------=_NextPart_000_001B_01C838DB.AE987740
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



charset=3Dus-ascii">

Re: Documentation for PostgreSQL win32 ODBC-Driver 8.02.05.00 and connection strings

--- On Fri, 12/7/07, Jochen Westland [invigo] 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 pgfoundry site that hosts the odbc project would keep a link for current documentation that we all to refer to (much like the 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 download the 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/psqlodb c/docs/config-opt.html

Here is where you can look for all other information:
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodb c/docs/

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Documentation for PostgreSQL win32 ODBC-Driver 8.02.05.00 and connection strings

--- On Fri, 12/7/07, Richard Broersma Jr 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 some kind of hex value? Perhaps the options that you set are additive?

http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlo dbc/psqlodbc/docs/config.html?rev=1.8&content-type=text/html

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Known SQLCancel issues?

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.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend