OLEDB Connection

[#1]

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!

[#2]

Hi,

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

$(Include = filename ).

[#3]

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?

[#4]

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.