Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC dev vs prod connection issue

Hi,

I am having an issue with the ODBC connect statement:

I am connecting to different DB on dev and prod and they have different names and credentials on dev and prod. The prod setup only has a server enviroment (no desktop) so I need to script the connection string on dev and push the app to prod.

How can I get the prod connection string in my script without having to actually connect to the prod DB.

3 Replies
giakoum
Partner - Master II
Partner - Master II

If both databases are the same then you just need to change the names. If you have scramble connect user credentials in the settings enabled , disable it so that you can directly enter the username and password. In any case, the DB admin should be able to provide you with the connections string.

Not applicable
Author

Hi, where can I disable the scramble user name and password? I have also requested the DBA to provide me a connection string

giakoum
Partner - Master II
Partner - Master II

Capture.PNG