When troubleshooting issues regarding connection to Data Source, it is crucial to determine whether a Connection String is correctly created.
Although QlikView has a built in wizard to generate connection string, this article tries to generate connection string externally.
Follow these steps:
- Create a new TXT file, name it as "string.txt".
![User-added image](https://qlik.my.salesforce.com/servlet/servlet.ImageServer?id=015D0000003s8so&oid=00D20000000IGPX&lastMod=1491475713000)
- Rename it to "string.udl". Note "Hide extensions for known file types" option needs to be turned off in Windows.
![User-added image](https://qlik.my.salesforce.com/servlet/servlet.ImageServer?id=015D0000003s8st&oid=00D20000000IGPX&lastMod=1491475744000)
- Double-click "string.udl", "Data Link Properties" window shows up.
![User-added image](https://qlik.my.salesforce.com/servlet/servlet.ImageServer?id=015D0000003s8sy&oid=00D20000000IGPX&lastMod=1491475774000)
- Choose appropriate provider in "Provider" tab, modify the settings in "Connection" tab so that Test Connection succeeds.
![User-added image](https://qlik.my.salesforce.com/servlet/servlet.ImageServer?id=015D0000003s8t3&oid=00D20000000IGPX&lastMod=1491475788000)
- Hit OK to save the file. Then open it in Text Editor, the Connection String should be there.
![User-added image](https://qlik.my.salesforce.com/servlet/servlet.ImageServer?id=015D0000003s8t8&oid=00D20000000IGPX&lastMod=1491475805000)
- By default the generated Connection String does not include Password. In order to establish successfully connection, a clear text "Password=XXXXXX" needs to be inserted into the string. This is for test purposes only and should not be used in production.