cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
Ressel
Ressel
Level VII

ODBC connection not working after elevating from JMP 17 to JMP 18

Created: Apr 28, 2025 06:06 AM  |  Last Modified: Apr 28, 2025 11:19 PM (2197 views)

Following elevation from JMP 17 to JMP 18 my ODBC connection stopped working. In JMP 17, it was used for various SQL queries embedded into Open Database() as well as New SQL Query() functions, pulling data from Google BigQuery. Depending on how I try to connect, I get slightly different error messages:

 

Open Database(), error message from log:

Ressel_0-1745834489950.png

 

New SQL Query():

Windows user ID and password don't work in this window.

Ressel_1-1745834516894.png

 

Create database connection via > File > Open Database > New Connection > Sign in:

Ressel_2-1745834598210.png

 

I also created a new DSN from scratch, which didn't work either. The ODBC is not the latest version, as our IT restricts which versions we can use due to presumed bugs. Is it wrong to assume that if the ODBC connection worked in JMP 17 it should also work in JMP 18?

0 Kudos
10 REPLIES 10
Dahlia_Watkins
Staff Dahlia_Watkins
Staff
Solution

Re: ODBC connection not working after elevating from JMP 17 to JMP 18

May 12, 2025 04:56 PM (1817 views)  |  Posted in reply to message from bryan_boone 05-12-2025

I've created a JMP Note that helps users experiencing this JMP Note 872545. 

cc: @Ressel 

Recommended Articles