how to create connection string fiels(.cfg)?

Anonymous — Mon, 24 Nov 2014 11:11:51 GMT

Re: how to create connection string fiels(.cfg)?

Peter_Cammaert — Mon, 24 Nov 2014 15:07:04 GMT

You're a bit sparse on details, but let's assume that you want to keep your connection string external to your model. One way to do this is as follows:

Put your entire CONNECT statement in a simple text file, for example "fiels.cfg" from your thread title. Create this file in Notepad, and enter the following:

ODBC CONNECT TO [connectionstring];

OLEDB CONNECT TO [connectionstring];

Replace connectionstring with the actual Connection String you configured using the Connect-wizard. Place the file "fiels.cfg" in the same directory as your QlikView document.

Now in your QlikView document, open the script editor and enter the following before any SQL statements you may have listed:

$(INCLUDE=.\fiels.cfg);

This will tell the QlikView engine to replace the INCLUDE statement with the text found in the specified file. You now have a method to change/adjust connection strings on the fly (e.g. for development or production databases) without touching your QlikView document.

Best,

Peter

topic how to create connection string fiels(.cfg)? in QlikView

how to create connection string fiels(.cfg)?

Re: how to create connection string fiels(.cfg)?