Microsoft KB Archive/182893

= PRB: Dos Perros Shopping Cart Error Under IIS 4.0 =

Article ID: 182893

Article Last Modified on 5/2/2006

-

APPLIES TO


 * Microsoft Visual InterDev 1.0 Standard Edition
 * 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.



MORE INFORMATION
For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:

http://support.microsoft.com/search/default.aspx?qu=vinterdev

Keywords: kberrmsg kbprb KB182893

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.