How do I force my .NET application to run as administrator also access sqlite?

Question

0.00/5 (No votes)

See more:

C#

I have create Set up file for WPF application and the database is SQLite DB. After the installation the SQLite DB is located this path in C folder, and the application is running properly on any computer that without an administrator Password PC.

C:\Program Files (x86)\myCompany\myScanApp.

C#

public SQLiteConnection dbConnection = new SQLiteConnection(@"Data Source=C:\Program Files (x86)\myCompany\myScanApp\test.s3db;");

C#

The problem is, it is failing to login after running this application if any other administrator password set PC. How can I solve this problem?

How can I access Sqlite DB from C drive after installation WPF application if pc have administrator password ?

What I have tried:

I am using this connection string:-

C#

public SQLiteConnection dbConnection = new SQLiteConnection(@"Data Source=C:\Program Files (x86)\myCompany\myScanApp\test.s3db;");

Posted 18-Nov-16 7:07am

Rajesh Kumar 2013

Updated 18-Nov-16 9:24am

v2

Add a Solution

Comments

Rajesh Kumar 2013 18-Nov-16 13:15pm

Kindly advise me for a right solutions

[no name] 18-Nov-16 13:33pm

You need to store your database file somewhere other than "Program files"

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2016-11-18T09:24:00

Solution 1

First, you database should NOT be under Program Files. Everything under Program Files is ReadOnly. I'm guessing that's probably why you think you need admin permissions to run your app. Don't.

The correct solution is to put your database under a more appropriate folder, like C:\ProgramData\company\appName. This location is ReadWrite for everyone. You'll also have to change the connection string to point to it there.

Posted 18-Nov-16 9:24am

Dave Kreskowiak

Comments

Rajesh Kumar 2013 18-Nov-16 23:16pm

Hello,

How can I create new database path like this: (C:\ProgramData\company\appName\test.s3db) in many other local mechines that run this windows applicaiton using c# code?

Dave Kreskowiak 19-Nov-16 10:04am

Take a look on your own machine at what's under the path C:\ProgramData. Look at how files and folders are typically arranged in there. Your database file needs to be placed in a known path under this folder that you come up with. Your installer needs to put the database file there.

Once you have that known path, you can build your connection string using a call to Environment.GetFolderPath(SpecialFolder.CommonApplicationData) and Path.Combine(). Read the documentation on both methods to see what they do.

This is very simple string manipulation. You're building a path from a well-known folder, adding the company and appname folder names you came up with, and your database name. That string going into your connection string in code. Again, very simple string manipulation. You can put some replacable tag in your connection string and, after you build the path to the database file, Replace that tag with your file path.