Re: [BUGS] BUG #11608: ODBC driver crashes after wrong password entered

Eric Hill <eric.hill@jmp.com>

From: Eric Hill <Eric.Hill@jmp.com>
To: "Inoue, Hiroshi" <inoue@tpf.co.jp>
Cc: Michael Paquier <michael.paquier@gmail.com>, PostgreSQL mailing lists <pgsql-odbc@postgresql.org>
Date: 2014-10-11T17:28:26Z
Lists: pgsql-bugs
Hey, Hiroshi,

I am developer on the JMP statistical visualization tool dev team (www.jmp.com<http://www.jmp.com>).  This is a desktop application that runs on Windows and Mac.  Our product uses ODBC calls to connect to ODBC data sources and retrieve data.  We have both 32-bit and 64-bit versions of the product.  The scenario we are seeing this problem with is 64-bit JMP talking a Windows PostgreSQL server.  The connection string is coming from the driver.  I looked in the driver dialog to see if there was a way to specify SSL or something, but I did not see anything.

I have not tried connecting to the PostgreSQL server from Excel or Access, because I have 32-bit versions of those products installed and the 64-bit PostgreSQL ODBC driver.  I'd be willing to try a 32-bit scenario with Excel as the client if you think that would help.

Thanks,

Eric

Sent from Windows Mail

From: Inoue, Hiroshi<mailto:inoue@tpf.co.jp>
Sent: ?Saturday?, ?October? ?11?, ?2014 ?5?:?19? ?AM
To: Eric Hill<mailto:Eric.Hill@jmp.com>
Cc: Michael Paquier<mailto:michael.paquier@gmail.com>, PostgreSQL mailing lists<mailto:pgsql-odbc@postgresql.org>

Hi Eric,

On 2014/10/10 22:09, Eric Hill wrote:
> Hey, Hiroshi,
>
> Not that I am aware of.  Here is the full connection string:
>
> DSN=PostgreSQL35W;DATABASE=postgres;SERVER=rdcesx07044.race.sas.com;PORT=5432;UID=postgres;PWD=%_PWD_%;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1c20502bb;A1=7.4;

Hmm this connection seems to use neither ssl nor libpq.
Are you using MS tools like MS access or excel?

regards,
Hiroshi Inoue