topic OLEDB Connection in QlikView

OLEDB Connection

Tue, 18 Oct 2011 14:59:09 GMT

I have a question regarding the OLEDB Connection. We are using SVN as a version contol and we want to control all our scripts. But when we are commiting files to the SVN we want to exclude passwords related text in the connection string.

So my question is if there is a way where I can put the whole "OLEDB CONNECT TO..." in a file stored locally on my computer and in someway include that file in the Qlikview script?

Thank ahead!

Re: OLEDB Connection

Tue, 18 Oct 2011 15:08:33 GMT

Hi,

yes it is possible you can store your connection into the file and call the file using the include

$(Include = filename ).

OLEDB Connection

Tue, 18 Oct 2011 15:14:54 GMT

Hi,

Sorry, that didnt work. I've tried to set up a connection with the database connect button and typed in all required fields and try the connection, that works. But if I copy the connection string and store it in a file and include it in the script as: $(Include=..\common_scripts\connect_to_db.txt); it did not work.

is there another solution?

Re: OLEDB Connection

Tue, 18 Oct 2011 15:25:56 GMT

Best option is to use the Include Syntax.

You can refer the below link http://community.qlik.com/message/114699#114699.

I am using include statement for quite long time and it is working fine.