"Could not delete from specified tables."

Valore · May 5th, 2010, 06:16 AM

Greetings everyone!

First of all, please excuse me if this is not the appropriate forum, or if this post is not complete with debug information. I'm a PHP programmer, and not used with .NET at all, but I have a project to debug a companys administrative part of their website.

Here comes the error message:
Server Error in '/' Application.

Could not delete from specified tables.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Could not delete from specified tables.

Source Error:

Code:

Line 22:             //oDel.DeletePictures();
Line 23: 
Line 24:             Offer.Del(Convert.ToInt32(Request.QueryString["ID"]));
Line 25:             Response.Redirect("~/admin/ErbjudandeEdit.aspx?action=view");   
Line 26:         }

Source File: d:\customers\njutagotland.se\wwwroot\admin\uc\Offe rs.ascx.cs Line: 24

Stack Trace:

Code:

[OleDbException (0x80004005): Could not delete from specified tables.]
   Microsoft.VisualBasic.CompilerServices.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) +202
   Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure) +150
   Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) +178
   Mecs.DataAccess.DB.Exec(String execString) +93
   Mecs.BaseObject`1.Del(T objBaseObject) +80
   Mecs.BaseObject`1.Del(Int32 Pk1Val) +130
   admin_uc_Offers.Page_Load(Object sender, EventArgs e) in d:\customers\njutagotland.se\wwwroot\admin\uc\Offers.ascx.cs:24
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

The company have a similar website up and running already, they were launching a similar project on another location so I basicly just copied the website and put it on the new server. First it didn't work, so I edited a "web.config" file and set some paths etc to the new ones, so the website and database worked fine in front-end mode (read). What does not work is the administrative part. I can't add, edit or delete partners/news/etc. Since read is standard, but edit is not I figured I need to set some privileges/rights.

What I know of .NET is that it uses tons of files and files only. The database is a .mdb (Microsoft Access?), so my suggestion is that the server does not allow the script to edit the database file. Could anyone help me please?

PS. If you need any further information, please let me know.

* I forgot to add, if I'm right above, is it possible to fix this without having server access? I only have FTP access, already tried to chmod the database files with no success.

Kind Regards,
Andreas.

samjudson · May 5th, 2010, 06:40 AM

This appears to be an Access database issue, and not related to the ASP.Net code, although its hard to be definite about that.

You'd need to know exactly what SQL your data access layer is trying to execute, and then try and work out why that isn't working.

A google of the error "Could not delete from specified tables." reveals lots of issues with deleting from multiple tables, but I don't know how that would affect you.

Valore · May 5th, 2010, 06:47 AM

Quote:

Originally Posted by samjudson

This appears to be an Access database issue, and not related to the ASP.Net code, although its hard to be definite about that.

You'd need to know exactly what SQL your data access layer is trying to execute, and then try and work out why that isn't working.

A google of the error "Could not delete from specified tables." reveals lots of issues with deleting from multiple tables, but I don't know how that would affect you.

Thanks for your quick answer. I've tried searching for pretty much every possible strings on google, they all say the same thing. That I need to set edit/delete rights for the script towards the database.

The code should be fine, since it works on the other website perfectly. I can read from the database in the administration panel, but not edit/delete them. Don't you think it's about privileges?

What I need to know, if is it's possible to edit the rights without server admin access.

Regards,
Andreas.

samjudson · May 5th, 2010, 06:49 AM

Well if it is its likely simply Windows security. You just need to make sure the ASP.Net user has read/write access to the file.

The quickest way to see if this is the issue it to give Everyone access to the database file - if that fixes it then you know it was permissions and can try to work out which user the ASP.Net app is trying to run as.

Valore · May 5th, 2010, 09:09 AM

Problem solved. I changed the privileges for Network Service to write for the database folder and all sub-items.

Thanks for the answers!

Regards,
Andreas.