Skip to main content
Question

How to configure SQLExecutor to connect to correct database at run-time?

  • April 23, 2020
  • 3 replies
  • 35 views

ravibansal
Contributor
Forum|alt.badge.img+4

For one user, SQLExecutor is correctly changing to connect to DEVSQL\\High at run-time. For another user, the default parameters specified in the SQLExecutor (QASQL\\High as shown above) are being used. What user configuration setting needs to change in order to correctly grab the same database as user #1 is getting?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

chrisatsafe
Contributor
Forum|alt.badge.img+2
  • Contributor
  • 606 replies
  • April 24, 2020

Hi @ravibansal,

One thing I would confirm, is whether the user is running from the latest feature cache or if they are re-running the entire workspace. It sounds like they might have feature caching enabled and they are viewing the data from the previous connection because it has been cached.


ravibansal
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • 17 replies
  • April 27, 2020

Hi @ravibansal,

One thing I would confirm, is whether the user is running from the latest feature cache or if they are re-running the entire workspace. It sounds like they might have feature caching enabled and they are viewing the data from the previous connection because it has been cached.

Hi @chrisatsafe, Both users, (logging into the server from their respective accounts) are running the Entire Workspace (feature caching is disabled).


chrisatsafe
Contributor
Forum|alt.badge.img+2
  • Contributor
  • 606 replies
  • April 27, 2020

Hi @chrisatsafe, Both users, (logging into the server from their respective accounts) are running the Entire Workspace (feature caching is disabled).

Hi @ravibansal,

Ok you should just need to create a user parameter for the connection then: https://www.screencast.com/t/aJQRXWhtuO

Since you are going between users, it's likely best to use a shared database connection otherwise they both need to have the 2 connection names exactly the same.

Hope that helps