PRB: Dos Perros Shopping Cart Error Under IIS 4.0 (182893)
The information in this article applies to:
- Microsoft Visual InterDev 1.0
- Microsoft Active Server Pages 1.0
This article was previously published under Q182893 SYMPTOMS
The following error occurs when trying to add items to the shopping cart of
the "Dos Perros Chile Company" sample site:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Errors occurred
The error references the file "/Shopping/Asp/Inserti.asp."
This issue occurs when the "Dos Perros Chile Company" sample site is
installed on an IIS 4.0 server.
CAUSE
The Dos Perros Chile Company sample site stores the Session.SessionID value
to keep shopping cart items together per session. The Session.SessionID
value is stored in the "SessionID" field of the "OrderItems" table of the
"Perros.mdb" file that is included with the "Dos Perros Chile Company"
sample site. The "SessionID" field of the "OrderItems" table is a text
field with a length of five characters. IIS 4.0 Session.SessionID values
are nine characters long. A failure results from trying to store a nine
character value in a five character field.
RESOLUTION
The Perros.mdb file can be located in the Database folder of the Dos Perros
Chile Company sample site. Open the Perros.mdb file in Microsoft Access.
In Design mode on the OrderItems table in the Perros.mdb file, increase the
length of the SessionID field to 10.
NOTE: The Perros.mdb file is an Access 95 database. If you are using Access
97, you will need to convert the database before you can alter the
OrderItems table. From the Tools menu, point to Database Utilities and
click Convert Database.
STATUS
Microsoft is researching this problem and will post new information here in
the Microsoft Knowledge Base as it becomes available.
| Modification Type: | Major | Last Reviewed: | 5/2/2006 |
|---|
| Keywords: | kberrmsg kbprb KB182893 |
|---|
|