Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Services > OleDb May Cause A Problem?

Reply
Thread Tools

OleDb May Cause A Problem?

 
 
Arif Çimen
Guest
Posts: n/a
 
      04-19-2005
Hi all folks,

I wrote simple code like that:

try

{

//oleDbConnection1.="Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry
Path=;Jet OLEDBatabase Locking Mode=1;Data Source=".\Project Request
Database\ProjectRequestDB.mdb";Mode=Share Deny None;Jet OLEDB:Engine
Type=5;Provider="Microsoft.Jet.OLEDB.4.0";Jet OLEDB:System database=;Jet
OLEDB:SFP=False;persist security info=False;Extended Properties=;Jet
OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Create System Database=False;Jet OLEDBon't Copy
Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk
Transactions=1";//../Project Request Database/ProjectRequestDB.mdb";

//oleDbConnection1.DataSource="../Project Request
Database/ProjectRequestDB.mdb";

string currDir=Server.MapPath("");

//string =Directory.GetCurrentDirectory();

currDir=currDir+"\\Project Request Database\\ProjectRequestDB.mdb";

oleDbConnection1.ConnectionString="Provider=Micros oft.Jet.OLEDB.4.0; Data
Source="+currDir;

oleDbConnection1.Open();

oleDbCommand1.Parameters["Name"].Value=TextBox3.Text;

oleDbCommand1.Parameters["Surname"].Value=TextBox2.Text;

oleDbCommand1.Parameters["Project_Title"].Value=TextBox4.Text;

oleDbCommand1.Parameters["Project_Details"].Value=TextBox5.Text;

oleDbCommand1.Parameters["e_mail"].Value=TextBox6.Text;

//oleDbCommand1.Parameters[""].Value=TextBox3.Text;

oleDbCommand1.ExecuteNonQuery();

}

finally

{

oleDbConnection1.Close();

}



And the server error comes:



What may be the reason?

Thanks for any help.

//++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++



Server Error in '/test' Application.
--------------------------------------------------------------------------------

Operation must use an updateable query.
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: Operation must use an
updateable query.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[OleDbException (0x80004005): Operation must use an updateable query.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
+41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +174
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
+92
System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,
Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +67
Test.WebForm1.Button1_Click(Object sender, EventArgs e) in
e:\websayfamiz1\test\webform1.aspx.cs:97
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292





--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
BSOD cause may be rootkit infection Sweetpea NZ Computing 0 02-13-2010 02:10 AM
Error: may cause a runtime exception because it is a field of a marshal-by-reference Rob Dob ASP .Net 4 03-30-2006 03:14 PM
AspCompat="true" on a Windows 2003 may cause an error Angelo Brusati ASP .Net 3 03-31-2005 02:22 PM
will all these messages cause a problem . I am a new subscriber and my computer is downloading 100,000 messages. Will this cause any kind of a problem with my ability to store other items?? Camille White Camille White Computer Support 9 11-08-2004 01:13 AM
This window is busy closing this windows may cause some problem dd Computer Support 2 04-09-2004 07:58 PM



Advertisments