Re: Getting DSN settings via ODBC? - Mailing list pgsql-odbc

From Tsunakawa, Takayuki
Subject Re: Getting DSN settings via ODBC?
Date
Msg-id 0A3221C70F24FB45833433255569204D1F5B7E28@G01JPEXMBYT05
Whole thread Raw
In response to Getting DSN settings via ODBC?  ("Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de>)
List pgsql-odbc
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jan-Peter Seifert
> is it possible to get the DSN's psqlODBC specific settings (PROTOCOL, "Level
> of Rollback on errors" etc.) via ODBC (information) functions?

The only method seems to get completed connection string via OutConnectionString of SQLDriverConnect().

https://msdn.microsoft.com/en-us/library/ms715433(v=vs.85).aspx

When I specified "DSN=postgres" to InConnectionString, I got the following string in OutConnectionString.  A1 is the
protocoland level-of-rollback setting.
 


DSN=postgres;DATABASE=postgres;SERVER=localhost;PORT=5450;UID=tunakawa;PWD=;CA=d;A6=;A7=100;B0=255;B1=8190;BI=0;C2=dd_;CX=1c305088a;A1=7.4

Why do you want to know psqlODBC-specific settings in your program?

Regards
Takayuki Tsunakawa


pgsql-odbc by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [BUGS] BUG #14260: psqlODBC does not support sslXXXXX variables
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: psqlODBC 09.05.0200 Released