Klaus Opitz 2 Posted November 22, 2021 Share Posted November 22, 2021 Along the same lines as a recent post regarding displaying data adapter variables, does anyone know how to display data adapter connection parameters from within a procedure. Specifically, I would be interested in displaying the URL as well as the Connection Name when a simple report procedure is run. I would think this would be possible, but so far my searches have come up empty. Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted November 30, 2021 Share Posted November 30, 2021 Klaus, I recommend opening a support case. Link to comment Share on other sites More sharing options...
Brian Suter Posted November 30, 2021 Share Posted November 30, 2021 There are some commands to query connections which could be redirected into a file. The old devstudio used them (I dont remember if they are documented). I am not sure they show the URL and it might be considered a security issue if they show that to non admin staff (information exposure). You would have to do a systables FMI request to get the connection name from your master file. Link to comment Share on other sites More sharing options...
Drew DeBaecke Posted November 30, 2021 Share Posted November 30, 2021 TABLE FILE SYSAPPS PRINT APPNAME APPLOC FNAME SUFFIX SUFFIX FTYPNAM CONNECT CONNUSER TABNAME WHERE FNAME EQ car WHERE SUFFIX NE END Link to comment Share on other sites More sharing options...
Toby Mills Posted November 30, 2021 Share Posted November 30, 2021 Hi Klaus Out of curiosity: What database are you using What do you hope to gain by trapping the info youre asking about Wondering what the larger picture is in case theres another way to solve your issue. Thanks Link to comment Share on other sites More sharing options...
Klaus Opitz 2 Posted November 30, 2021 Author Share Posted November 30, 2021 Hi Toby, In this particular case we are going against a MySql database using a JDBC connection. There are a couple of databases that we are switching between (for DEV/QA efforts), so displaying the connection would help non-technical users to self-serve in determining what database the environment is currently pointed to. That being said, I do have another way to get to this and it will work just as well. I can simply select the database name and display it in a fex. That will give the users enough to go on. I was just curious if the data adapter connection parameters were accessible after reading a recent post regarding the display of other data adapter parameters. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now