Problem administrator password in windows application.

Abhilash J A

10y903

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

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.

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

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 ? Please advise me for a right solutions

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta10y ago
Accepted answer
Yes, you can also go through the path (c:\programdata) and create folder to save your data.

Use Directory.Create ( path)
+2
Abhilash J A10y ago
Yes I am calling db from this location.

Please look up this link I have included add details.

http://stackoverflow.com/questions/40689467/where-to-store-my-windows-applications-data
public SQLiteConnection dbConnection = new SQLiteConnection(@"Data Source=C:\ProgramData\company\appName\test.s3db;");
0
Amit Gupta10y ago
Are you calling your db from the same directory?
+2
Abhilash J A10y ago
Hello Amit,

Thanks for reply me.. I did write connection string like this..
public SQLiteConnection dbConnection = new SQLiteConnection("Data Source=test.s3db;Version=3.5.1;");
But it occured error: "SQL logic error or missing database"
I have doubt. The database test.s3db have 3 tables and coloumns then using this connectionstring how can the application identify each tables and coloumn?
0
Amit Gupta10y ago
There should not be an issue whether the system is password protected. It can cause some issue if current user is a standard user and not an administrator. So if standard user want to access the c:\programFiles, they donot have such permission.

Secondly, it is recommended to use the db path as only db name only like
datasource=test.s3db

It signifies that db exist in the current directory.

Try renaming the datasource.
Or if you want to access other resources then I suggest you to use an admin authentication, so that your program always get executed as an administrator

You need to add an app.manifest. Change therequestedExecutionLevel fromasInvoker to requireAdministrator

Do let me know if it solves your problem
+2