Re: Getting DSN settings via ODBC?

From: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
To: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Getting DSN settings via ODBC?
Date: 2016-07-21 01:12:10
Message-ID: 0A3221C70F24FB45833433255569204D1F5B7E28@G01JPEXMBYT05
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)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 protocol and 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2016-07-24 03:19:01 Re: psqlODBC 09.05.0200 Released
Previous Message Michael Paquier 2016-07-21 00:33:07 Re: [BUGS] BUG #14260: psqlODBC does not support sslXXXXX variables