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: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Mo
Mo
Level III

SQL Missing under Machine Data Source - How to Fix?

Dec 16, 2019 11:45 AM (3733 views)

I haven't connected to databases a lot but recently got set up to access a SQL data base. However, when trying to set up the connection, under "Machine Data Source" I don't see SQL listed (just Access and Excel). Before a recent computer upgrade I know I did have SQL listed there, just now it isn't. Can anyone tell me what I need to do to get this here?

0 Kudos
3 REPLIES 3
pmroz
Super User pmroz
Super User

Re: SQL Missing under Machine Data Source - How to Fix?

Dec 16, 2019 02:14 PM (3721 views)  |  Posted in reply to message from Mo 12-16-2019

What sort of SQL database is it?  Oracle, SQL Server, MySQL etc.?

Mo
Mo
Level III

Re: SQL Missing under Machine Data Source - How to Fix?

Dec 16, 2019 02:32 PM (3718 views)  |  Posted in reply to message from pmroz 12-16-2019

SQL server I believe.

0 Kudos
briancorcoran
Staff briancorcoran
Staff

Re: SQL Missing under Machine Data Source - How to Fix?

Created: Dec 17, 2019 08:20 AM  |  Last Modified: Dec 17, 2019 5:23 AM (3693 views)  |  Posted in reply to message from Mo 12-16-2019

Hi Monique,

 

In order to get this working, you're going to need to learn about ODBC drivers and how to set them up.  It is extremely important to first find out what database you are accessing.  Otherwise, you will not be able to install the correct software to connect to the database.  This is not a JMP thing, it is a database access issue for any software.  Programs like Excel also use ODBC to access SQL data.

 

ODBC provides a common access mechanism to your database.  Once you find out which database you are accessing, you'll need to search on ODBC driver and that database, like "ODBC driver SQL Server 2014".  The operating system is important.  Many Windows ODBC drivers are free, but Mac drivers usually must be purchased. The download site for the drivers that you find will tell you how to start the installer. An example of a SQL Server ODBC driver download is at https://www.microsoft.com/en-us/download/details.aspx?id=36434.

 

After that, you'll need to get connection information particular to your database, like the machine name, and credentials to access the data.  This must be entered in to the driver setup.  If you have IT support staff in your organization, I would try to talk to them as they will know how to do this.

 

Brian