topic Re: How to get database connections that have been used in current JMP session in Discussions

How to get database connections that have been used in current JMP session

Georg — Wed, 10 Dec 2025 16:03:10 GMT

Dear community,

when I connect first time to a database (e.g. ODBC-connection that are listed in my ODBC Database administrator under Windows),
I need to authenticate and it takes some extra time to set everything up.

When I do it the second time during that session, it works w/o authentication and it is a little faster.

How can I identify the connections that have been used during my current session by JSL?

I would like to have a list of elements that is shown by Query Builder in the Connections box below.

Is this possible at all?

Thanks a lot and BR

Re: How to get database connections that have been used in current JMP session

jthi — Wed, 10 Dec 2025 16:16:01 GMT

I'm not sure if some stuff from Data Connector Registry() could do that JSL Syntax Reference > JSL Messages > Data Connector Messages

@briancorcoran

Re: How to get database connections that have been used in current JMP session

bryan_boone — Wed, 10 Dec 2025 18:36:24 GMT

There's not currently a list of say, "active connections" available through JSL. The second time "quick connection" occurs since jMP is able to either use an existing (active) connection or connect with an already complete and valid connection string.

The Data Connector Registry only maintains a list of configurations much like that of ODBC Database administrator under Windows and not a list of "active connections".

@Georg can you add that to the wish list? Otherwise a JSL user would have to maintain the list in the script.

Re: How to get database connections that have been used in current JMP session

Georg — Thu, 11 Dec 2025 09:34:17 GMT

Thanks for your suggestion,

I added a wish: Get database connections from current JMP session - JMP User Community