[NTISP] ASP problem when writing to Access database in IIS 4, MDAC 2.0SP1

Josh Hillman ( (no email) )
Wed, 24 Mar 1999 13:15:43 -0500

We have a customer that's trying to get an ASP page to update an Access
database on our system, but it always spits out the following error and no
one knows why (reading from the database via ASP pages works fine):

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
/test.asp, line 7

The source code for the ASP file is below. I've searched through MS'
KnowledgeBase, but the only thing that I've come across that resembles this
is something that relates to InterDev 6, which is not being used in relation
to this site/page/database.

This is not the only .mdb file that this is happening with. Using MSQuery
here on the network, I can update the table without any problems using the
same SQL statement. Also, a Cold Fusion file can write to the database
without any problems. I've tested security issues by going so far as to
give "Everyone" full control over the directory containing the .mdb file as
well as the .mdb fileitself.
Any ideas why this is happening? I know nothing about ASP pages/coding, so
I have no idea.

Technical info:
Webserver:
Dual Pentium II 266, 256MB RAM
NT 4.0 SP4, IIS 4.0
MDAC (MS Data Access Components) 2.0 SP1
MS Access ODBC driver version: 3.51.171300
Access database/table info:
Table name: Products (less than 100kB in size)
Columns:
ProductsID
(autonumber, long integer, Increment)
ProductName
(length=50, not required, allowed zero length, indexed)
ProductDescription
(length=255, not required, no zero length, not indexed)
ASP file source code (the line starting with VALUES is actually on the same
line as the INSERT INTO statement--it's word-wrapped to its own line in this
email message only):
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "test"
Set rs = Server.CreateObject("ADODB.RecordSet")
sql = "INSERT INTO Products(ProductName, ProductDescription)
VALUES(12345,6789)"
'response.write(sql)
rs.Open sql, conn, 1
Response.Redirect("testdone.asp?ID=" & idGroup)
Conn.Close
%>

Thanks for any help,
Josh Hillman
hillman@talstar.com

For more information about this list, including removal,
see this url: http://www.iea-software.com/maillist.html