Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Honored Contributor II

Re: ODBC dev vs prod connection issue

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

Re: ODBC dev vs prod connection issue

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

giakoum
Honored Contributor II

Re: ODBC dev vs prod connection issue

Capture.PNG

Community Browser