Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > BOOK: Beginning ASP 3.0
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP 3.0 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 2nd, 2004, 06:54 PM
Registered User
 
Join Date: Jan 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 14--SQLUpdate.asp Try it out

I seem to have hit a road block on this try it out. I am getting an error when I run this in my browser:

Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/aspfiles/sqlupdate.asp, line 30

I checked the code many times even letter by letter. (I missed a punctuation in chapter 12) and everything checks out. I even used the code from the Wrox downloads. Same error.

Here is the code:

<%
    option explicit
    dim strConnect
%>





<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Using SQL's UPDATE Command and the ADO Command Object</title>
</head>

<body>
<%
    dim objComm, intNoOfRecords
    Set objComm = Server.CreateObject("ADODB.Command")

    Response.Write "<B>Harry the Ham directs Quentin Tarantino films?</b><br>"
    objComm.ActiveConnection = strConnect

    objComm.CommandText = "UPDATE AllMovies SET Director = 'Harry the Ham' " &_
                        "WHERE Director LIKE 'Quentin Tarantino'"
    objComm.CommandType=adCmdText
    objComm.Execute intNoOfRecords

    Response.Write "This UPDATE command has affected " & intNoOfRecords & " records<br><br>"

    Response.Write "<b>Tarantino returned to his rightful place as director:</b><br>"
    objComm.CommandText = "UPDATE AllMovies SET Director = 'Quentin Tarantino' " &_
                        "WHERE Director LIKE 'Harry the Ham'"

    objComm.Execute intNoOFRecords
    Response.Write "This UPDATE command has affected " & intNoOfRecords & " records<br><br>"

    Set objComm = Nothing
%>
</body>

</html>

I checked the Access files and nothing seems to be configured to make the database "un-updateable"

Any ideas?

BTW there is nothing on the errata list I downloaded from this site (it has chapter 8's errors then skips to chapter 15 for the application)

Thanks,
JB977
  #2 (permalink)  
Old February 3rd, 2004, 05:03 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

http://www.aspfaq.com/show.asp?id=2062
  #3 (permalink)  
Old February 3rd, 2004, 10:33 PM
Registered User
 
Join Date: Jan 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by pgtips
 http://www.aspfaq.com/show.asp?id=2062
Thanks for the tip, I went there and found a few articles from that source and the MS KB but it is rather confusing how to get the permissions set up correctly. I tried to do what the KB articles said and I still get the error.

 Anyone have a source with a clear explanation of how to go about this? Seems rather complicated and involves a lot of tinkering. The book almost makes it seem like it should work easily w/out going through a lot of hoops to make this "try it out" work."

Thanks,
JB977
  #4 (permalink)  
Old February 4th, 2004, 09:06 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

For starters I would check 2 basic things. In Windows Explorer, right-click the folder where the mdb file resides, and choose 'Properties' from the pop-up menu
1. is the mdb file marked as read-only within windows (unlikely but worth checking anyway)
2. on the security tab, check that IUSR_machineName is listed in the 'Group or user names' list.
2.1 If it is listed, check that it has read and write permissions (if it doesn't then add them by checking the relevant box in the bottom list)
2.2 If it isn't listed, use the Add button to add it to the list, then check the read and write boxes in the bottom list.

Let us know how you get on.
rgds
Phil
  #5 (permalink)  
Old February 4th, 2004, 09:34 AM
Registered User
 
Join Date: Feb 2004
Location: worceter, , United Kingdom.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I had the same problem, I managed to get it sorted. Heres how:

http://p2p.wrox.com/topic.asp?TOPIC_ID=9360

Cheers,

John.
  #6 (permalink)  
Old February 4th, 2004, 02:08 PM
Registered User
 
Join Date: Jan 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by john_reeve41
 Hi,

I had the same problem, I managed to get it sorted. Heres how:

http://p2p.wrox.com/topic.asp?TOPIC_ID=9360

Cheers,

John.
Well, that did the trick! Thank you for your help both of you (john_reeves41 and pgtips). It is weird, but the MS KB on file sharing says you should have the simple file sharing checked. Funny thing is, I remember seeing the security tab in the folder properties before when exploring XP after installing it. No doubt I will run into more problems as I wade my way through this book. Once I hit Chapter 15 the errors report will help me again, as my edition was an earlier version. If I need help again, I'll be back! Thanks again!

Thanks,
JB977
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
chapter 14 vthunder70 BOOK: Beginning ASP.NET 2.0 and Databases 2 October 3rd, 2007 02:11 PM
Chapter 14 example pkumar@ech BOOK: Professional Jakarta Struts 0 November 15th, 2006 09:10 AM
Chapter 14 JonG BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 March 21st, 2006 10:04 PM
Chapter 14 Mike Smith BOOK: Professional C#, 2nd and 3rd Editions 2 January 4th, 2004 05:13 PM
Chapter 14 XML starsol Beginning PHP 2 July 18th, 2003 10:27 AM



All times are GMT -4. The time now is 06:48 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.