Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
Monique
Level III

SQL Missing under Machine Data Source - How to Fix?

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?

3 REPLIES 3
Highlighted
pmroz
Super User

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

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

Highlighted
Monique
Level III

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

SQL server I believe.

Highlighted

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

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

 

 

Article Labels

    There are no labels assigned to this post.