topic Re: Adding data source (DSN) in Discussions

Adding data source (DSN)

GilGC — Tue, 02 Sep 2025 14:30:33 GMT

Hello comunity,

I am using JMP 18 on macOS Sequoia 15.6.
I am using Database > Open table (or Data Connector) to add a data source I want to using.

I click on New connection... and it shows the data sources (DSN) I have set up on ODBC.

I select the data source I want and click on Choose DSN and I get this error.

I am quite certain I have set up my DSN correctly.

Anyone using the same OS that has been able to connect to a DSN using ODBC?

Re: Adding data source (DSN)

bryan_boone — Thu, 04 Sep 2025 18:42:55 GMT

That looks like an encoding problem from the driver. Which one are you using?
and was there a "Test" button on the Connection Manager (ODBC Manager or iODBC Administrator)?

Re: Adding data source (DSN)

GilGC — Tue, 07 Oct 2025 14:38:04 GMT

Hello Bryan, thank you for your reply.

I am using the following driver

No, there is no "Test" button on the ODBC Manager.

Re: Adding data source (DSN)

bryan_boone — Sun, 19 Oct 2025 22:31:44 GMT

I've had better experience with the ActualTech driver on macOS for Postgres (and other datasources)
I'll see if there's anything JMP can do with you particular Postgres driver.
The diamonds you see in the message are coming from the driver, not JMP, which would point to utf encoding errors.