topic Check if ODBC data source is available (win)? in Discussions https://community.jmp.com/t5/Discussions/Check-if-ODBC-data-source-is-available-win/m-p/718056#M89988 <P>I want to check if a specific ODBC datasource is available on a user's computer.</P><P>Due to speed issues, I don't want to Create a Database connection but just: see if the datasource setting is available.</P><P><BR />Is there a JSL command to get this info?</P><P>&nbsp;</P><P>&nbsp;</P> Sun, 21 Jan 2024 16:41:20 GMT hogi 2024-01-21T16:41:20Z Check if ODBC data source is available (win)? https://community.jmp.com/t5/Discussions/Check-if-ODBC-data-source-is-available-win/m-p/718056#M89988 <P>I want to check if a specific ODBC datasource is available on a user's computer.</P><P>Due to speed issues, I don't want to Create a Database connection but just: see if the datasource setting is available.</P><P><BR />Is there a JSL command to get this info?</P><P>&nbsp;</P><P>&nbsp;</P> Sun, 21 Jan 2024 16:41:20 GMT https://community.jmp.com/t5/Discussions/Check-if-ODBC-data-source-is-available-win/m-p/718056#M89988 hogi 2024-01-21T16:41:20Z Re: Check if ODBC data source is available (win)? https://community.jmp.com/t5/Discussions/Check-if-ODBC-data-source-is-available-win/m-p/718077#M89995 <P>Most likely you could use <A href="https://www.jmp.com/support/help/en/17.2/#page/jmp/utility-functions.shtml?os=win&amp;source=application#ww4547957" target="_self">Run Program()</A>&nbsp; and <A href="https://learn.microsoft.com/en-us/powershell/module/wdac/get-odbcdsn?view=windowsserver2022-ps" target="_blank">Get-OdbcDsn (Wdac) | Microsoft Learn</A>.&nbsp;</P> Mon, 22 Jan 2024 06:18:20 GMT https://community.jmp.com/t5/Discussions/Check-if-ODBC-data-source-is-available-win/m-p/718077#M89995 jthi 2024-01-22T06:18:20Z Re: Check if ODBC data source is available (win)? https://community.jmp.com/t5/Discussions/Check-if-ODBC-data-source-is-available-win/m-p/718258#M90064 <P>Thanks&nbsp;<a href="https://community.jmp.com/t5/user/viewprofilepage/user-id/14366">@jthi</a>&nbsp;.</P><P>&nbsp;</P><P>JMP + Run Program -&gt; Powershell is really powerfull.</P> Wed, 24 Jan 2024 07:22:56 GMT https://community.jmp.com/t5/Discussions/Check-if-ODBC-data-source-is-available-win/m-p/718258#M90064 hogi 2024-01-24T07:22:56Z