Connection String

[#1]

Hi all

we are using oracle database ......  when we move the application from one server(DEV)  to another(UAT)  business want the OLE DB Connect string to be changed to that server credentails through and external notepad file. So the credentails should be only changed in the external notepad file.They do not want us to change the coonection string manually in the application.

Any help on this would be appreciated.

[Oleg_Troyansky]

The best way to achieve this is to extract your connect string into and external txt file and to use INCLUDE to include it back into the script. This way, you can have 2 difference versions of the connection strings on 2 different servers, and QlikView script won't need to be modified for each transition.