topic ODBC dev vs prod connection issue in QlikView https://community.qlik.com/t5/QlikView/ODBC-dev-vs-prod-connection-issue/m-p/446265#M697068 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am having an issue with the ODBC connect statement:</P><P></P><P>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. </P><P></P><P>How can I get the prod connection string in my script without having to actually connect to the prod DB. </P></BODY></HTML> Fri, 15 Mar 2013 14:52:49 GMT 2013-03-15T14:52:49Z ODBC dev vs prod connection issue https://community.qlik.com/t5/QlikView/ODBC-dev-vs-prod-connection-issue/m-p/446265#M697068 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am having an issue with the ODBC connect statement:</P><P></P><P>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. </P><P></P><P>How can I get the prod connection string in my script without having to actually connect to the prod DB. </P></BODY></HTML> Fri, 15 Mar 2013 14:52:49 GMT https://community.qlik.com/t5/QlikView/ODBC-dev-vs-prod-connection-issue/m-p/446265#M697068 2013-03-15T14:52:49Z Re: ODBC dev vs prod connection issue https://community.qlik.com/t5/QlikView/ODBC-dev-vs-prod-connection-issue/m-p/446266#M697069 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 15 Mar 2013 14:59:17 GMT https://community.qlik.com/t5/QlikView/ODBC-dev-vs-prod-connection-issue/m-p/446266#M697069 giakoum 2013-03-15T14:59:17Z Re: ODBC dev vs prod connection issue https://community.qlik.com/t5/QlikView/ODBC-dev-vs-prod-connection-issue/m-p/446267#M697070 <HTML><HEAD></HEAD><BODY><P>Hi, where can I disable the scramble user name and password? I have also requested the DBA to provide me a connection string</P></BODY></HTML> Fri, 15 Mar 2013 15:20:34 GMT https://community.qlik.com/t5/QlikView/ODBC-dev-vs-prod-connection-issue/m-p/446267#M697070 2013-03-15T15:20:34Z Re: ODBC dev vs prod connection issue https://community.qlik.com/t5/QlikView/ODBC-dev-vs-prod-connection-issue/m-p/446268#M697071 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="35060" class="jive-image-thumbnail jive-image" onclick="" alt="Capture.PNG" src="https://community.qlik.com/legacyfs/online/35060_Capture.PNG" width="450" /></P></BODY></HTML> Sat, 16 Mar 2013 14:12:16 GMT https://community.qlik.com/t5/QlikView/ODBC-dev-vs-prod-connection-issue/m-p/446268#M697071 giakoum 2013-03-16T14:12:16Z