Обсуждение: 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

От
"Jochen Westland [invigo]"
Дата:
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_"
 
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

От
Richard Broersma Jr
Дата:
--- 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

От
Richard Broersma Jr
Дата:
--- 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.

Known SQLCancel issues?

От
Alon Goldshuv
Дата:
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.