Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-CE
I am developing a small windows form with sqlCE. i made an installer to deploy it to another machine. I added the MyDB,sdf to the Application Folder. but when i run the application it gives me following error.
 
Access to the database file is not allowed. [ File name = MyDB.sdf ]
 
i checked the folder in program file(86) and it contain the .sdf file but can't figure it out what is the problem.
 
my connection string is string ConString = @"Data Source=MyDB.sdf";
 
any idea what i am doing wrong?
Posted 9-Aug-12 18:57pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

"Program Files" in Windows is protected, so normal users cannot write there, your applications will probably work with an administrator user.
 
Change the data folder path for your database to somewhere where all users have permission to write.
  Permalink  
Comments
SR.Rizwan at 10-Aug-12 2:50am
   
how can i change the folder and specify it in the installer?
Mehdi Gholam at 10-Aug-12 3:08am
   
Consult your installer documentation, for your code make the database path a configuration point (instead of hard coding).

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

  Print Answers RSS
0 CHill60 330
1 OriginalGriff 285
2 CPallini 198
3 BillWoodruff 170
4 Sergey Alexandrovich Kryukov 168


Advertise | Privacy | Mobile
Web02 | 2.8.141015.1 | Last Updated 10 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100