I am developer on the JMP statistical visualization tool dev team (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.
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?