.NET SQLite and Click-Once Deployment

Question

Have a smartclient application that is distributed using Click-Once, but also includes a SQLite DB for a local cache.

The problems is that once the app is published it doesn't seem to be able to open the SQLite DB file. Have included the DB file as part of the install process...

Any thoughts?

System.Data.SQLite.SQLiteException: Unable to open the database file — Jan de Jager
– Jan de Jager, Commented Sep 2, 2009 at 14:00
How are you creating your deployments? Visual Studio? If so, what version 2005, 2008? — codeConcussion
– codeConcussion, Commented Sep 2, 2009 at 15:05

codeConcussion · Accepted Answer · 2009-09-03 15:56:37Z

3

When a ClickOnce application is set to "Full Trust", on install it will prompt the user to grant full trust. This means that the application will have all the same privileges on the computer as the user running the application (editing the regisitry, file io, etc). You mentioned in the comments that the app is set to full trust, so it would appear that it's not a security issue.

Are you certain all of the necessary files are getting deployed? I would just remove ClickOnce from the picture. Look at all the files in your deployment, create a folder and copy all those files into it, then try to run it. Does it work? My initial guess is that some needed file is not being included in the ClickOnce deployment.

answered Sep 3, 2009 at 15:56

codeConcussion

13k8 gold badges52 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin · Accepted Answer · 2009-09-03 16:02:28Z

1

Check the path that your app is using to get to the database. Virtuallized paths can cause these sorts of problems on Vista and above.

Then check the read/write permissions on the database file.

answered Sep 3, 2009 at 16:02

Martin

2,44414 silver badges17 bronze badges

Comments

Parsa · Accepted Answer · 2009-09-02 11:39:56Z

0

Have you included the SQLite provider in the package?

answered Sep 2, 2009 at 11:39

Parsa

1,1151 gold badge18 silver badges38 bronze badges

1 Comment

Jan de Jager Over a year ago

Yes, its just not able to open the db file. Works fine when debugging, which makes me thing it might be a security thing?

Toss Net · Accepted Answer · 2018-04-03 08:37:30Z

0

I had a same problem. My solution was to add SQL.interop.DLL (x32 and x64) in the Visual Studio Project (as link) so that the ClickOne Deploiment add those files in this "package" Look this blog post : http://webbercross.azurewebsites.net/ef7-sqlite-click-once-deployment-error/

answered Apr 3, 2018 at 8:37

Toss Net

5508 silver badges13 bronze badges

Collectives™ on Stack Overflow

.NET SQLite and Click-Once Deployment

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related