Re: ASP & Databases

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: McKirahan (News_at_McKirahan.com)
Date: 04/05/04 

Date: Mon, 05 Apr 2004 11:09:50 GMT

"Jim Bowman" <anonymous@discussions.microsoft.com> 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.
>
> Any suggestions?
>
> Thanks.
>
> Jim

This worked for me:

1) Open Control Panel then click Folder Options then scroll to the
bottom and turn off "Simple File Sharing"

2) Open Windows Explorer, right-click on the database's folder, click
Properties, click on the (now revealed) Security tab then select Everyone
then click the "Write" checkbox the click "Apply".

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: allowing access to a .mba from IIS 6.0
    ... This isn't a function of IIS. ... Then you can use ASP to access the db. ... WebPageChecker - Helps Maintain Server UpTime ... >A website that my company took over uses an access database for .asp ...
    (microsoft.public.inetserver.iis)