Transition to Expression Web issue (Full Version)

All Forums >> [Web Development] >> ASP, PHP, and Database

Message

---

stu -> Transition to Expression Web issue (6/2/2009 11:18:46) I am going thru the transition from fp2003 to EW 2.0 and am having a problem getting the 'Insert into' and 'delete' functions to work on an Access 2002 database. I'm using the standard Data Controls under the ASP.NET section of the EW toolbox. Everything seems to work well. All functions work in the localhost. When I try it on the server, I can see the contents of the database table (indicating that the connection is working - I guess) but the Insert funtion generates an error that says "Operation must use an updateable query" The Insert statement generated by EW is: InsertCommand="INSERT INTO [BRCUSOpen] ([name], [comments], [paid]) VALUES (?, ?, ?)" Does this seem like a problem with a setting on the server, which I'm told is set up for dotNet?

---

treetopsranch -> RE: Transition to Expression Web issue (6/2/2009 12:47:08) Since this forum has discontinued the Expression Web section I have been going to this Expression Web Forum for help. Lots of Expression Web experts there.

---

stu -> RE: Transition to Expression Web issue (6/2/2009 13:34:42) Thanks treetopsranch. I'll post on that forum. Since you're one of the people who convinced me to go to EW (from an earlier post), do you have any comment on my issue? So far, I'm impressed with the capabilities of EW and with ASPNet, but i need to get past this issue.

---

ou812 -> RE: Transition to Expression Web issue (6/2/2009 17:50:48) Just a quick guess, but you may want to look and make sure your database is writeable. The error you describes seems it is having difficulties accessing to delete or insert, and probably update.

---

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.03125