Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 4th, 2004, 08:25 AM
Registered User
 
Join Date: Feb 2004
Location: worceter, , United Kingdom.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 14 page 580 Problems with example

Hi,

I am having problems with the SQLUpdate.asp example on this page.

The error message I receive is:

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/begasp/sqlupdate.asp, line 22


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)

Page:
GET /begasp/sqlupdate.asp

Any help on this would be greatly appreciated.

Many thanks,

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

see http://p2p.wrox.com/topic.asp?TOPIC_ID=9293
  #3 (permalink)  
Old February 4th, 2004, 09:32 AM
Registered User
 
Join Date: Feb 2004
Location: worceter, , United Kingdom.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the responses.

I managed to get it fixed. that link you gave was a bit vague simply because I'm not familiar with Windows XP administrative tasks. My problem was I had simple file sharing enabled which prevented me from explicitly allowing access rights to the database.

Here's how to do it (explained as if you're two years old - just the way I like it)

1. In the folder where your files and database is kept (ie /BegASPFiles) click tools, folder options, view scroll down to the bottom of the list and uncheck use simple file sharing.

2. Right-click on the database file and choose properties click security, click add and type in the name of the internet guest account which is IUSR_machinename (replace machinename with the name of your computer).

3. Tick the allow full control box and click ok.

That should do it. If it still doesn't work, try moving the database file into the directory with the asp files (ie /BegASPFiles).

Cheers.

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

Ah yes, simple file sharing does get in the way a bit.

You really need to add permissions to the folder that contains the mdb file, not just the mdb file itself. This is because access uses an ldb file too (in the same folder) and the IUSR_blahblah account needs to be able to control that file too.

Anyway, glad its working for you now.

rgds
Phil


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 14 Code page 620, help needed! Safi BOOK: Beginning ASP 3.0 3 December 8th, 2010 12:43 PM
Chapter 14 JonG BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 March 21st, 2006 10:04 PM
Chaper 14 - over $1000 problems ftb_tx BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 November 21st, 2004 09:15 PM
Chapter 14 Mike Smith BOOK: Professional C#, 2nd and 3rd Editions 2 January 4th, 2004 05:13 PM
Chapter 14 Page 780-781 JonR BOOK: Professional C#, 2nd and 3rd Editions 0 August 11th, 2003 08:27 PM





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