Changing the database password

[#1]

Hi,

I created the following connection string using qlikview wizard :

OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=SOURCE;Data Source=XE] (XPassword is TKGJRaUGVJNKTaEGRBIB);

I want to be able to change the database password (from a development environment to a production environment) without going through the wizard again and I don't want to delete the connection string and regenerate it.

Is there a solution to this requirement with Qlikview or do I have every time to regenerate the connection.

Thanks

[maxgro]

make 2 oledb connections (dev and prod)

use a variable and an if statement to change from dev and prod

you can further improve it adding an external file from which you read the variable; so when you change from dev to prod you only change the external file

[Colin-Albert]

You could keep the connection details in a separate text file and use a $(include) line to select the relevant connection file. That way the live documents will select the live connection and development dpocuments will connect to the dev data.

[PradeepReddy]

Just create 2 connection strings one for Dev and other for Prod.

Comment out the connection string, in  which region u are not working  on..

EX: 

Assume bellow is the  2 connection strings

Connection_String_Dev

Connection_String_Prod

If u are working in Dev region, use the bellow format

Connection_String_Dev

// Connection_String_Prod

If u are working in Prod region, use the bellow format

//Connection_String_Dev

Connection_String_Prod