| From: | Michiko Kawamoto <michiko(dot)kawamoto(at)perfectdayfoods(dot)com> |
|---|---|
| To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | AWS PostgreSQL Encoding and Connection Issue on JMP |
| Date: | 2020-06-12 21:59:53 |
| Message-ID: | BYAPR14MB29190BE8FED357EAE3C49E9482810@BYAPR14MB2919.namprd14.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hello psqlODBC team,
We have a PostgreSQL instance on AWS. I would like to make a connection to the database on JMP. I installed the ODBC driver via Homebrew (I am on Mac Catalina) and set up DSN with psqlodbca.so driver. I was able to make a connection to the db successfully, but I noticed that the first 2 rows had encoding issues, so I thought that I should switch over from psqlodbca.so to psqlodbcw.so driver since the db encoding is UTF-8. When I use the psqlodbcw.so driver, it's not able to connect to the db.
* JMP® 15.0.0
* macOS Catalina Version 10.15.5
* Driver path: /usr/local/Cellar/psqlodbc/12.01.0000/lib/psqlodbcw.so
I would greatly appreciate your feedback.
Thank you,
Michiko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Inoue, Hiroshi | 2020-06-15 12:06:01 | Re: [PATCH] Allow field set from a joined query |
| Previous Message | Autade, Kalpana (Kalpana) | 2020-06-08 11:59:27 | (-1/HY000/1) out of memory for query result for getting Bytea |