User Community
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: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
hogi
hogi
Level XIII

Check if ODBC data source is available (win)?

Jan 21, 2024 11:41 AM (1417 views)

I want to check if a specific ODBC datasource is available on a user's computer.

Due to speed issues, I don't want to Create a Database connection but just: see if the datasource setting is available.


Is there a JSL command to get this info?

 

 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User jthi
Super User
Solution

Re: Check if ODBC data source is available (win)?

Jan 22, 2024 01:18 AM (1389 views)  |  Posted in reply to message from hogi 01-21-2024

Most likely you could use Run Program()  and Get-OdbcDsn (Wdac) | Microsoft Learn. 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User jthi
Super User
Solution

Re: Check if ODBC data source is available (win)?

Jan 22, 2024 01:18 AM (1390 views)  |  Posted in reply to message from hogi 01-21-2024

Most likely you could use Run Program()  and Get-OdbcDsn (Wdac) | Microsoft Learn. 

-Jarmo
hogi
hogi
Level XIII

Re: Check if ODBC data source is available (win)?

Jan 24, 2024 02:22 AM (1349 views)  |  Posted in reply to message from jthi 01-22-2024

Thanks @jthi .

 

JMP + Run Program -> Powershell is really powerfull.

0 Kudos

Recommended Articles