Problem with MDB file in Asp.Net application

I have been using Microsoft Access database to store some infrequently changed information for quite some time. It worked well until recently I began to use GoDaddy Hosting plan.

I uploaded my application to my GoDaddy hosting server, made some changes online, and downloaded to my local development environment because I noticed that the online change did not work as I expected.

With some debug, I found that I got a strange exception with all update SQL statement.

System.Data.OleDb.OleDbException was caught
Message="Operation must use an updateable query."
Source="Microsoft JET Database Engine"
ErrorCode=-2147467259
StackTrace:
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()

I did some search online and found that it looks most likely a write permission issue to the MDB file. I checked the property of my downloaded mdb file and found it was changed to "ReadOnly". After I turned off the "Readonly" property of the file, the exception disappear immediately. I then realized that GoDaddy hosting server might have change the file property for me.

After calling GoDaddy technique support, I was told that by default my App_Data folder was read only and I could change the folder permission online myself.

Followed the instruction of the nice technique support, I logged into my GoDaddy account, chose to manage my hosting account, and in the Host Control Center webpage, click the "Your Files" tab which is the first link button. Now I was in the file manager page of GoDaddy and could easily change write permission for any of my file folders.

However, the problem still existed. Even after I changed the folder to writable, and the mdb file is writable now, I still can not run my update statement. After I download the file to my local, the file becomes "read only" again.

I then managed to write a XML file in the folder and noticed that even though the XML file is also Readonly, I am able to overwrite the file.

It looks that GoDaddy is still limiting the MDB file writing permission. But for other files they are OK.

Comments

  1. Good articelJanuary 29, 2010 at 4:16 AM

    Thans to you

    ReplyDelete
  2. AlexApril 18, 2010 at 1:03 PM

    I know many other tools. But yesterday no one of theirs couldn't help me with corrupted access files. Fortunately later I found in the Internet - MDB Recovery. It resolved my trouble for a minute and free of charge as I kept in mind. Moreover the utility helped some of my friends too.

    ReplyDelete
  3. BloggerOctober 6, 2016 at 6:02 AM

    Are you trying to make money from your visitors with popup ads?
    In case you do, have you ever consider using EroAdvertising?

    ReplyDelete

Post a Comment

Popular posts from this blog

Javascript Hosted on Google Drive Not Working Reliably

Here is the story. I have been using Google Drive to host the javascript files and stylesheet files all the time. It works perfectly, until a few days ago when I noticed that if the web page contains javascript files hosted at Google Drive, it can not be viewed properly from the Facebook built in web browser.  I did some further investigation. The same thing happened when the page is opened in Wechat built in browser.  However, the page works fine when it is opened in most browsers, like IE, Chrome, Firefox. It took me several hours to figure why. And So far I have not find out the reason. I checked the mime type of the files. They are correctly recognized by Google Drive. But the solution is: moving the files out of Google Drive. Now it works perfectly, in browser and in App built in web browsers as well.
Read more

Newsmag Theme and External Featured Image

The  NewsMag  wordpress theme is a fast and simple.  It is excellent for a news, newspaper, magazine, publishing or review site. It also supports videos from YouTube and features a rating system. It uses the best clean SEO practices, and on top of that, it’s fast, simple, and easy to use. In addition, News mag supports responsive Google Ads and AdSense. The problem I had with this theme is that it does not work with  Nelio External Featured Image  by default. You can follow the steps in this article to make the theme and the plugin work with each other Nelio External Featured Image Not working with Newsmag theme Another useful information is here:  Solution fix thumn for theme Newsmag when using module Nelio External Featured Image Unfortunately whenever the theme is updated, the update to the theme will get lost. Therefore it is not a good idea to use the   Nelio External Featured Image  plugin. After some research, I found a...
Read more

Responsive Web Design

Google has an document about  How to Building Smartphone-Optimized Websites . In this document, responsive web design is the first suggestion. I have been looking for a easy to implement responsive css framework that can change my websites layout so that they can fit to smart phone device for quite a little while. However, most of them requires more than a css file.  After searching aroung, I found a good article that introducts 10 well adopted grid frameworks  10 Lightweight & Minimal Responsive Grid Frameworks Among them, the  Simple Grid  is very clean and simple. It does not work well on IE 7 or IE 8. Other than that, it works fine.  The  Proportional Grids  is also a quite stable and simple one. For a website that involves user input, I would recommend  Base Framework which is almost ready to use so that you do not have to worry about the user input formatting. It is very important to add following line to the he...
Read more