Page 1 of 1

Dynamically setting the connection string expression

Posted: Mon 26 Oct 2009 14:23
by dwango121
Hi,

Can anyone confirm that I can dynamically set the connection string expression in a Connection Manager using the dotconnect driver to a variable that holds the full path to a sqlite database.

I have successfully done this for a flat file Connection Manager for text files but when I try the above it just errors. I will post the exact errors later.

Thanks in advance for any help!!

Al

Posted: Wed 28 Oct 2009 12:01
by Shalex
Yes, you can use the ConnectionManager class (http://msdn.microsoft.com/en-us/library ... nager.aspx). Please specify the errors you have encountered and the steps we should follow to reproduce the problem.