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.
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.