Re: ASP & Databases

From: Roland Hall (nobody_at_nowhere)
Date: 04/05/04 

Date: Sun, 4 Apr 2004 21:40:58 -0500

"Jim Bowman" wrote in message
news:153dc01c41a95$698241d0$a601280a@phx.gbl...
: I am unable to insert a row in a database using an .asp
: page. I am running IIS 5.1 that comes with Windows XP.
:
: I can read a row from the database using an .asp page
: that includes the SQL SELECT statement. But when I use
: the sample code in Lesson 3 (Creating a Guest Book using
: a Database) from Module 1 (Creating ASP Pages) from the
: IIS documentation, I get an error message: "Microsoft
: JET Database Engine (0x80004005) Operation must use an
: updateable query." The Lesson 3 code uses the SQL INSERT
: statement.
:
: Related issues:
: -The Win XP documentation recommends "Before you install
: IIS, you need to install the Windows TCP/IP Protocol and
: Connectivity Utilities." I have been unable to find the
: TCP/IP and connectivity utilities.
: -Permissions may be the cause. I can't change them
: because the IIS Snap-in panel doesn't appear when I right
: click Control Panel and click Manage|Services &
: Applications|Internet Information Services. IIS Snap-in
: is, however, listed as installed in Add/Remove Programs
: in Control Panel.
: -There is no network connected to my PC. I am the
: computer admimnistrator.

Hey Jim...

This generally happens when you have do not have permissions at the file
system level. You can modify permissions with Windows Explorer for the
anonymous user. The path you're writing to is usually physical, not virtual
and should not be under the web root.

If you only need to modify files, you do not need full rights. This
included adds/mods/deletes re: records in a database.

HTH... 

-- 
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

Relevant Pages

  • Re: Problem: DLL VB6 / ASP / Database / Windows 2003
    ... Since the code run in ASP/IIS needs to access other resources (database here) in your second case, the user account configured in IIS for the ASP must have permission to access the said database. ... Dim rs As Recordset ...
    (microsoft.public.vb.general.discussion)
  • Re: 404 Redirect Question
    ... the database for. ... >>>>So what I want it to do is the 404 page ASP code will look at the page>>name 'Cars_Motorbikes' search the categories database table and pull>>out the category information. ... >>>>So in IIS I tried setting the Custom Errors 404 Message Type as File>>but IIS does not or I can't get this page to process it as ASP to then>>dynamically build the page. ... >>>>The 2nd thing I tried was setting the Message Type as URL. ...
    (microsoft.public.inetserver.asp.general)
  • ASP & Databases
    ... I am unable to insert a row in a database using an .asp ... I am running IIS 5.1 that comes with Windows XP. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Database Not Seen
    ... Out of the box IIS supports ASP and installs the FP2000 extensions. ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... >> have never used the Database Interface Wizard in the past. ...
    (microsoft.public.frontpage.client)
  • Re: ASP & Databases
    ... > I am unable to insert a row in a database using an .asp ... I am running IIS 5.1 that comes with Windows XP. ... > in Control Panel. ...
    (microsoft.public.inetserver.asp.db)