Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Problems Arising When Migrating to New Server

Reply
Thread Tools

Problems Arising When Migrating to New Server

 
 
Will Chamberlain
Guest
Posts: n/a
 
      10-06-2005
I just moved a web application to it's new home on the server. One
feature of the application allows a user to create sort of a portfolio.
They start this process by typing into a textbox the name of the
portfolio, submitting, adding items. When I run this from VS.net
(localhost) it works fine. After uploading it to the server I get an
error stating:

Exception Details: System.Data.OleDb.OleDbException: Operation must use
an updateable query.

[OleDbException (0x80004005): Operation must use an updateable query.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32
hr) +41

System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPA
RAMS 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() +66
DrawingList.WebForm5.btnSubmitDrawingListNumber_Cl ick(Object sender,
EventArgs e) in C:\Inetpub\wwwroot\DrawingList\Index.aspx.vb:55
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.Rai
sePostBackEvent(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


As you can see, I have included the stack trace. I have no idea how to
read it and look for errors so if someone could give some feedback that
would be appreciated.

- will

---
"Our enemies are innovative and resourceful, and so are we. They never
stop thinking of ways to harm our country and our people, and neither do
we." President George W. Bush

*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
 
 
 
 
Will Chamberlain
Guest
Posts: n/a
 
      10-06-2005
Nevermind. Database permissions issue.

---
"Our enemies are innovative and resourceful, and so are we. They never
stop thinking of ways to harm our country and our people, and neither do
we." President George W. Bush

*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
 
 
 
 
=?Utf-8?B?U3JlZWppdGggUmFt?=
Guest
Posts: n/a
 
      10-06-2005
Are you using MS Access database?. I have seen this error with Access & ASP
because of permission issues... Granting write permission for ASPNET user
account on the FOLDER wheer MDB file may help


"Will Chamberlain" wrote:

> I just moved a web application to it's new home on the server. One
> feature of the application allows a user to create sort of a portfolio.
> They start this process by typing into a textbox the name of the
> portfolio, submitting, adding items. When I run this from VS.net
> (localhost) it works fine. After uploading it to the server I get an
> error stating:
>
> Exception Details: System.Data.OleDb.OleDbException: Operation must use
> an updateable query.
>
> [OleDbException (0x80004005): Operation must use an updateable query.]
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32
> hr) +41
>
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPA
> RAMS 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() +66
> DrawingList.WebForm5.btnSubmitDrawingListNumber_Cl ick(Object sender,
> EventArgs e) in C:\Inetpub\wwwroot\DrawingList\Index.aspx.vb:55
> System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
>
> System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.Rai
> sePostBackEvent(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
>
>
> As you can see, I have included the stack trace. I have no idea how to
> read it and look for errors so if someone could give some feedback that
> would be appreciated.
>
> - will
>
> ---
> "Our enemies are innovative and resourceful, and so are we. They never
> stop thinking of ways to harm our country and our people, and neither do
> we." President George W. Bush
>
> *** Sent via Developersdex http://www.developersdex.com ***
>

 
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
How does C handle issues arising out of Endianness? Indian.croesus@gmail.com C Programming 18 01-03-2007 07:45 PM
Problems migrating to new machine bh ASP .Net 3 04-18-2006 05:12 PM
Re: Problem arising from Outlook Jonathan N. Little HTML 3 06-12-2005 04:34 PM
Re: Problem arising from Outlook Toby Inkster HTML 0 06-12-2005 07:49 AM
migrating from a server to a new server curious fish Cisco 1 05-18-2005 03:49 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57