Solved

sqlite error "Unable to open database file"

Posted on 2010-08-15
3
1,773 Views
Last Modified: 2013-12-21
Hi,

I have code that I am trying to open sqlite database, I am getting error "Unable to open database file". My path to database is correct. I am working on Windows mobile,

My code:
string s = "Data Source=" + AppPath() + "\\DB\\test.sqlite";
            SQLiteConnection conn = new SQLiteConnection();
            conn.ConnectionString = s ;
            try
            {
            conn.Open();
            }
            catch(Exception ex)
            {
           
            }

Please help me to solve issue
0
Comment
Question by:mkk39
3 Comments
 
LVL 3

Expert Comment

by:bkokx
ID: 33444300
Do you have read/write access in that folder?
0
 
LVL 28

Expert Comment

by:strickdd
ID: 33444710
Definitely a permissions issue of some sort. Verify the user you are running under. Then on the folder and the test.sqlite file, right click and go to security. Verify that your user has all but Full Control on those. Easiest way is to check "Full Control" and then uncheck it, this will select everything but full control.
0
 
LVL 5

Accepted Solution

by:
sindhuxyz earned 500 total points
ID: 33548628
This is path issue. Make sure the path
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let me explain this picture a little bit.  First, in case you haven't already guessed, you are looking at my 2 phones, an Android Samsung Galaxy S5 on the left and an iPhone 5 on the right.  They are on their respective cradles on my desk.  But, you…
As the title indicates, I have done this before. It chills me everytime I update the OS on my phone, (http://www.experts-exchange.com/articles/18084/Upgrading-to-Android-5-0-Lollipop.html) because one time I did this and I essentially had a bricked …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question