topic Re: to connect to database through SQL in Discussions

to connect to database through SQL

Dennisbur — Mon, 01 Apr 2024 11:48:18 GMT

Hello

I would like to connect to the database through an SQL query.

I have written the JSL script

dt = Open Database (
"DRIVER = {SQL Server};
SERVER = HAISQLC162\HAISQLC162,3187
UID = hw_tests_viewer
PWD = ********
DATABASE = HW_Chip_Tests;"
,
"SELECT *

FROM [HW_Chip_Tests].[viewer].[chip_tests_row_data_3m_v]
where VID = 'S232NNC300578' "
);

but received error note: Data source name not found and no default driver specified

what I did wrong?

Re: to connect to database through SQL

jthi — Mon, 01 Apr 2024 12:21:42 GMT

To me it looks like the connection string is in wrong format. Usually they look like something like this

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

how it exactly looks like depends on your database, your driver, settings on PC and so on.

You can also try to create the connection using JMPs query builder and extract the connection string from there (it will Use New SQL Query instead of Open Database which I would also suggest you use as that is the method which is supposed to be supported in the future of JMP). The connection string it creates will be a bit different as it might prefix it with ODBC

Re: to connect to database through SQL

pmroz — Tue, 02 Apr 2024 12:59:36 GMT

Not sure if it's easier but you can also try File > Database > Open Table. You might need to create an ODBC user source. Once you open a table from SQL Server, you can find the connection string under the red or green triangle (depends on which version of JMP you are using).

Re: to connect to database through SQL

DualBison1041 — Mon, 25 Aug 2025 09:48:08 GMT

Any chance to show step by step how to get the connection string?

Re: to connect to database through SQL

Georg — Mon, 06 Oct 2025 09:33:23 GMT

Hi @DualBison1041 , yes there is a way to get the connection string, you can generate a JMP Database Query by:

File => Database => Query Builder (or in JMP 19 File=> Connect to => ODBC => Query Builder
select the connection you want (e.g. ODBC: new connection, computer data source ...)
Next
Build query
then e.g. save modify script to script window will show you the connection string