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).

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=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_"

well, some parts are quite obvious, like B1=3D8190, C2=3Ddd_, we just =
cant find
out, which parameter describes which option.

Can anyone help?



Best Regards



Jochen



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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Nachricht</TITLE>

<META content=3D"MSHTML 6.00.2900.3199" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D250325612-07122007>Hi
all,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D250325612-07122007>we
are currently quite unsucessfully looking for a documentation =
for the
win32 odbc-driver, current version (8.02.05.00).</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN
class=3D250325612-07122007></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D250325612-07122007>Is =
there a document
describing all features, eg Extra Opts 0x10, etc.?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN
class=3D250325612-07122007></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D250325612-07122007>Additionally were
looking for some help in understanding which option is set where =
in the
options of a connection string like </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial
size=3D2>strConn=3D"ODBC;DRIVER=3D{PostgreSQL};DATABASE=3Dmy Db;SERVER=3D1=
92.1 68.0.91 ;"
& =
_<BR> "PORT=3D5432;UID=3DmyDbUser;PWD=3Dpass;A0=3D0;A1=3D7.4;A2=3D 1;A3=3D0=
;A4=3D1;
A5=3D0;A6=3D;A7=3D100;A8=3D4096;A9=3D0;"<BR>&
_"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_"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><SPAN class=3D250325612-07122007><FONT face=3DArial size=3D2>well,
some parts are quite obvious, like B1=3D8190, C2=3Ddd_, we just =
cant
find out, which parameter describes which
option. </FONT></SPAN></DIV>
<DIV align=3Dleft>
<P align=3Dleft><FONT face=3DArial size=3D2><SPAN =
class=3D250325612-07122007>Can anyone
help?</SPAN></FONT></P>
<P align=3Dleft><FONT face=3DArial size=3D2></FONT> </P>
<P align=3Dleft><SPAN class=3D250325612-07122007><FONT face=3DArial =
size=3D2>Best
Regards</FONT></SPAN></P>
<P align=3Dleft><SPAN class=3D250325612-07122007><FONT face=3DArial
size=3D2></FONT></SPAN> </P>
<P align=3Dleft><SPAN class=3D250325612-07122007><FONT face=3DArial
size=3D2>Jochen</FONT></SPAN></P></DIV>
<DIV> </DIV></BODY></HTML>

------=_NextPart_000_001B_01C838DB.AE987740--
Jochen Westland [ Fr, 07 Dezember 2007 14:15 ] [ ID #1887913 ]

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

--- On Fri, 12/7/07, Jochen Westland [invigo] <jochen.westland [at] 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 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 [at] postgresql.org so that your
message can get through to the mailing list cleanly
Richard Broersma Jr [ Fr, 07 Dezember 2007 16:43 ] [ ID #1887914 ]

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

--- On Fri, 12/7/07, Richard Broersma Jr <rabroersma [at] 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 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
Richard Broersma Jr [ Fr, 07 Dezember 2007 16:54 ] [ ID #1887915 ]

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
Alon Goldshuv [ Mi, 12 Dezember 2007 05:29 ] [ ID #1888798 ]
Datenbanken » gmane.comp.db.postgresql.odbc » Documentation for PostgreSQL win32 ODBC-Driver 8.02.05.00 and connection strings

Vorheriges Thema: Need help with UnixODC to Postgres
Nächstes Thema: [ psqlodbc-Bugs-1010208 ] 64bit ODBC for Windows

[ Startseite ] [ Administrator ] [ Suche ] [ Hinweise ] [ Impressum ]

Powered by FudForum