cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

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