cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
GilGC
Level I

Adding data source (DSN)

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.

GilGC_0-1756822981194.png

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

GilGC_2-1756823219306.png

 

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

 

GilGC_3-1756823312152.png


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?

3 REPLIES 3

Re: Adding data source (DSN)

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)?

GilGC
Level I

Re: Adding data source (DSN)

Hello Bryan, thank you for your reply.

 

I am using the following driver

GilGC_0-1759840115959.png


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

GilGC_2-1759847594875.png

Re: Adding data source (DSN)

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.

Recommended Articles