How To Install Sqlite database to a specific path in a Visual Studio Package ?

Hi All,

I am developing a client -server application in Visual Studio 2005 C#.

I am using sqlite as my database.

When I build one click installation and install it on another machine the sqlite database is install on following default path which is
C:\Documents and Settings\lt\Local Settings\Apps\2.0\XTRXPMR6.CE0\LJEH924J.7R4\asce...exe_27e7cc688ee11b76_0001.0000_none_1a9ebedbf08f462c\Data\

What I want to do is install the sqllite database to a folder on c drive i.e C:\sqlite\

How can I do this in my Visual Studio which on build becomes one click installation.

Thanks a lot for the help in advance.

Aash.

matrix_aash

Asked: 2011-02-23

Advertise Here

1 Solution

LVL 42

Meir RivkinFull stack Software EngineerCommented: 2011-03-17

You can't. One of the design goals of ClickOnce applications is that they require no administrative privileges, and the only places you can write with impunity on Vista and Windows Fabulous (7) are under the user's profile.

http://social.msdn.microsoft.com/Forums/en/winformssetup/thread/5c7d00c2-2473-4fd5-b815-30066383eb47