Problem administrator password in windows application.

Question

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

Amit Gupta · Answer

Yes, you can also go through the path (c:\programdata) and create folder to save your data. Use Directory.Create ( path)

Amit Gupta · Answer

Are you calling your db from the same directory?

Amit Gupta · Answer

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 the requestedExecutionLevel from asInvoker to requireAdministrator Do let me know if it solves your problem

Abhilash J A · Answer

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	est.s3db;" );

Abhilash J A · Answer

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?