473,661 Members | 2,425 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Befuddled

Not sure if this is the correct place for this question, but I'm kind of
grasping for straws at this point.

I get an error message when deleting rows from a table in Access database.
The original vb.net code is included below. It is running in an Asp.Net
structure.

My understanding is that the error message relates to the sharing of the
Inetpub and the wwwroot directories. I have set the Sharing Property to
"Share this file"and Permissions have been set to "Full Control". I still
get the error.

I'm running Microsoft Windows XP, Professional, Version 2002, Service Pack 1.

The code is as follows and the error message is after it.
*************** ** Start Code *************** *****
<%@ import Namespace="Syst em.Data" %>
<%@ import Namespace="Syst em.Data.Oledb" %>

Sub Page_Load(Sende r as object, e as EventArgs)
if not isPostBack then

Dim Con As OleDbConnection = New OleDbConnection
Dim DA As OleDbDataAdapte r = New OleDbDataAdapte r
Dim ConnectString, delCmd, x as String

x = Server.Mappath( "\ASPClass\Fina lProj\DB.mdb")

ConnectString = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & x

Con.ConnectionS tring = ConnectString
delCmd = "DELETE FROM ORDERS"

DA.DeleteComman d = New OleDbCommand(de lCmd, Con)
Con.Open
DA.DeleteComman d.ExecuteNonQue ry()

end if
End Sub
*************** ***** End Code *************** *****

*************** ***** Start 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.Ole Db.OleDbExcepti on: Could not delete from
specified tables.

Source Error:

Line 29: DA.DeleteComman d = New OleDbCommand(de lCmd, Con)
Line 30: Con.Open
Line 31: DA.DeleteComman d.ExecuteNonQue ry()
Line 32: '************** *************** *******
Line 33: end if
Source File: c:\inetpub\wwwr oot\ASPClass\Fi nalProj\ShopSig nIn.aspx Line:
31

Stack Trace:
[OleDbException (0x80004005): Could not delete from specified tables.]
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(Int32 hr)
+41

System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPARAM S
dbParams, Object& executeResult) +154
System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object& executeResult)
+92
System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r behavior,
Object& executeResult) +65
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method) +112
System.Data.Ole Db.OleDbCommand .ExecuteNonQuer y() +54
ASP.ShopSignIn_ aspx.Page_Load( Object Sender, EventArgs e) in
c:\inetpub\wwwr oot\ASPClass\Fi nalProj\ShopSig nIn.aspx:31
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +29
System.Web.UI.P age.ProcessRequ estMain() +742
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.370 5.6018; ASP.NET
Version:1.0.370 5.6018

*************** ***** End Error Message *************** ******
Thank you for your help.

Mark

Nov 21 '05 #1
0 841

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
11764
by: Phil Powell | last post by:
$fbArray = array($feedbackCategoryArray => $feedbackCategoryArray); I can't begin to fathom in my befuddled mind how to sort this array $fbArray into alphabetical order according to $feedbackCategoryArray - I am utterly lost, can someone explain in detail how I would do it and why. Thanx Phil
2
1506
by: Befuddled | last post by:
Forgive me, this is probably a very simple problem, but it's new to me. When I attempt to make php 4.3.8, it exits, and I believe the relevant message is: libtool: link: cannot find the library `' I suspect it may be a problem with the Makefile, but more likely, I have failed to configure php correctly. Here's the configure command I used:
10
3224
by: Ian Rastall | last post by:
I would like to use an include for my header and navigation, and because subsequent files may be in different directories, I want to use a dynamic relative link for the images, sort of like: <img src="<? $root ?>/images/foo.gif" /> I suppose the easiest thing to do is just use absolute links, but is there a way to set this up so I can PHP instead? TIA
4
1923
by: John | last post by:
Hello. I am just wondering if someone can help me with my PHP/MySql code as I am not too proficient with it yet. What I am wanting to do, is display data from two tables. The first table is called wp_linkcategories and has a list of category names for my different links.
2
2740
by: Avi Kak | last post by:
Hello: I'd be most grateful if someone could answer the following questions about the exec functions in the os module. 1) How does one get one of the os.exec functions in Python to execute a shell script that includes some sort of a control structure in the shell script itself?
46
12020
by: Ioannis Vranos | last post by:
#include <iostream> int main() { using namespace std; cout<<"Best wishes for a Great Happy New Year to all!"<<endl; }
6
1537
by: puzzlecracker | last post by:
I have recently decided to go over the questions in the classical book by Murray and few of them admittedly befuddled me. page 140: 1. Under what circumstances should a smart compiler be able to use static binding for a virtual function call? (is it when base class pointer refers to base class object?) 2.Does it ever make sense to declare an inline virtual function? Under
3
290
by: tomrector | last post by:
I have been working on a CSV export of a query, my problem is that I need a header row like in a Report. Any guidance would truly be appreciated........ :) My query provides: month,year,amount,event,activity,accountnumber I need a header row as follows =Count(*), =Sum(),event,activity so the resulting text file will look like:
7
6714
geolemon
by: geolemon | last post by:
I'm getting an error, I'm not seeing the cause: Debug highlights this segment of code (I just snipped a portion here): strProc = "Insert into Parts (MfgPN, Manufacturer, Description)" & _ "select distinct PurchasedPN, Manufacturer, Description " & _ "from DBimport where PurchasedPN is not null " & _ "and PurchasedPN not in (select MfgPN from Parts) " & _ "group by...
0
8343
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8855
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8758
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7364
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6185
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5653
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
2762
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1986
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1743
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.