cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

SQL Connection

dkraeuter_sunne
dkraeuter_sunne
Level IV
Created: Feb 16, 2023 02:00 PM  |  Last Modified: Jun 8, 2023 9:35 AM 970 views

I have a SQL database stored on a virtual computer and JMP is on a different computer. Can I create a connection between the SQL database and JMP without having them on the same computer?

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User txnelson
Super User
Solution


Re: SQL Connection

Feb 16, 2023 02:53 PM (965 views)  |  Posted in reply to message from dkraeuter_sunne 02-16-2023

You will have to have an SQL ODBC driver for your database installed on the JMP computer to be able to connect.  JMP will talk to the local ODBC driver which in turn will talk to the ODBC driver on the SQL computer, which will talk to the SQL data

Jim

View solution in original post

1 REPLY 1
txnelson
Super User txnelson
Super User
Solution


Re: SQL Connection

Feb 16, 2023 02:53 PM (966 views)  |  Posted in reply to message from dkraeuter_sunne 02-16-2023

You will have to have an SQL ODBC driver for your database installed on the JMP computer to be able to connect.  JMP will talk to the local ODBC driver which in turn will talk to the ODBC driver on the SQL computer, which will talk to the SQL data

Jim

Recommended Articles