cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

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

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

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

 

Georg_0-1765382444361.png

 

Georg
2 REPLIES 2
jthi
Super User

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

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

@briancorcoran 

-Jarmo

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

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.

Recommended Articles