Click here to Skip to main content
12,403,856 members (69,128 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-CE SQL-Server
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 10-Aug-12 2:50am
   
how can i change the folder and specify it in the installer?
Mehdi Gholam 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 10 Aug 2012
Copyright © CodeProject, 1999-2016
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