IIS, ASP and Databases

[Jim Bowman]

I am unable to insert a row in a database using an .asp
page.

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

 

[Guest]

The answer turns out to be permissions in the folders
containing the database. There were read-only and that
status permitted a SELECT statement but blocked the
INSERT statement.

Jim Bowman