918784_en-US

liliconcom

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

 

 

Data AccessWindowsRe: 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 

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.

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

Thanks for your suggestion,

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