Read only error in mdf file after installing setup

Question

3.86/5 (4 votes)

See more:

Hello guys,
i have a problem,too many guys couldn't solve it,i created a project and created a datagridview,in it i created a database file(MDF),and i used linq to write and read,like updating,deleting and adding records to my database,at last my project is finished but ,when i create a setup for it,after installing sql server 2008,.net client profile,... when i run my app and try to update it,it says database is readonly.i don't have this problem in debugor release mode,can anyone help me?i'm putting too much time to solve this problem.

Posted 9-Apr-12 0:41am

F.moghaddampoor

Updated 4-Mar-20 5:23am

Add a Solution

Comments

Pablo Aliskevicius 9-Apr-12 8:07am

Is the .mdf file, on disk, actually read only? This could be so if the file was read only when you packed your installer. For instance, if your .mdf file is under source control, and you checked it in before packing your installer.

F.moghaddampoor 9-Apr-12 8:44am

Hello Pablo,
I checked the file attributes ,but its not readonly.

F.moghaddampoor 9-Apr-12 8:44am

and thanks for ur answer

F.moghaddampoor 9-Apr-12 8:45am

how can i take my files out of source control then?

F.moghaddampoor 9-Apr-12 9:12am

I just hesitate about your answer and went and after release mode,i debuged my code and then i copied release files to another folder,when i wanted to create setup i used the second folder,but still i have that error,readonly error.

F.moghaddampoor 9-Apr-12 9:13am

i copied my debug files to another computer manually,and my project worked correctly.but when i'm using setup to create shortcuts and having a destination folder for my project,it happens a readonly error.

F.moghaddampoor 9-Apr-12 9:15am

please help guys ,i'm miserable now!

F.moghaddampoor 9-Apr-12 9:48am

this is the error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.SqlClient.SqlException (0x80131904): Failed to update database "C:\PROGRAM FILES\DEFAULT COMPANY NAME\SETUPER2\F.MDF" because the database is read-only.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.DataContext.ExecuteMethodCall(Object instance, MethodInfo methodInfo, Object[] parameters)
at Serial_port_exporter.LINQDataContext.Storeintable(Nullable`1 row, String year, String month, String day, String hour, String minute, String second, String repetition, String x, String y, String z, String operator) in E:\Setups\majid-serial port exporter-4-7-2012-B\Serial port exporter 2\Serial port exporter\LINQ.designer.cs:line 86
at Serial_port_exporter.Form1.Btnadd_Click(Object sender, EventArgs e) in E:\Setups\majid-serial port exporter-4-7-2012-B\Serial port exporter 2\Serial port exporter\Form1.cs:line 180
at Serial_port_exporter.Form1.button4_Click(Object sender, EventArgs e) in E:\Setups\majid-serial port exporter-4-7-2012-B\Serial port exporter 2\Serial port exporter\Form1.cs:line 823
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.261 (RTMGDR.030319-2600)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Serial port exporter
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Default%20Company%20Name/Setuper2/Serial%20port%20exporter.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win3

majune 9-Apr-12 11:14am

It seems be a permission issue,do you have the permission to create/modify/delete a file in folder "C:\PROGRAM FILES\DEFAULT COMPANY NAME\SETUPER2"? you can try to create/modify/delete one file in the folder.

F.moghaddampoor 9-Apr-12 13:16pm

Yes it is a permission issue,i can change the user permission of mdf file and ldf file to write on the files but,after installation it get back to its first mode,readonly for users.even i can change the permission of the files after instalation and my program will work,but end users don't understand this,so i need to have free permission for every one.how can i do this?

F.moghaddampoor 9-Apr-12 13:18pm

majune how can we change attribute of database to write and read?plz tell me in good details.tnx before.

Sergey Alexandrovich Kryukov 15-Jan-13 17:04pm

I have to warn you: I found three "answers" in this forum, which you formally accepted. How can you explain that? This is the abuse, and the abuse can entail abuse reports and even the ban, in bad cases.
—SA

peter_shadows 24-Apr-13 10:35am

THAT'S OK..........BUT.....once you put the mdf file in the %AppData%. HOW SQLEXPRESS WILL FIND IT. IF THE |DataDirectory| IN THE CONNECTION STRING IS POINTING TO THE .EXE FOLDER ONLY???

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

pietvredeveld · Accepted Answer · 2012-04-09T05:42:00

Solution 1

You're database file is in %ProgramFiles%. It should be in %AppData%

Piet

Posted 9-Apr-12 5:42am

pietvredeveld

Comments

F.moghaddampoor 9-Apr-12 13:21pm

Hello pietvredeveld,can i ask you how can i put my database in AppData,when end user decide the app directory.

majune 10-Apr-12 10:46am

two way:
1.modify the setup project.
when you make the setup,you should specify the path of f.mdf,ensure that the file will install into AppData folder.
2.copy f.mdf to AppData folder by app.
every time you run you app,the first thing is to copy the file to AppData folder,
you can add the follow code in your Main(or init) method and try again:
-----------------------------------------------------------------------------------
string sourcePath=@"C:\PROGRAM FILES\DEFAULT COMPANY NAME\SETUPER2";
string appDataPath= Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
string fileName="F.MDF";
System.IO.File.Copy(sourcePath+"\\"+fileName, appDataPath+"\\"+fileName ,false);
----------------------------------------------------------------------------------
*1 is better.

F.moghaddampoor 17-Jan-13 9:15am

This is it. The answer is correct. Thank you very much. :)

F.moghaddampoor 10-Apr-12 10:50am

i'm really thanksful majune.i will try this.

member60 11-Apr-12 6:41am

my 5!

Volynsky Alex 26-Apr-14 10:22am

Nice answer :)

itsmahadi007 23-Feb-21 7:47am

but now the problem is how can i set the connection string to that location?