PRB: Dos Perros Shopping Cart Error Under IIS 4.0

• Microsoft Visual InterDev, version 1.0
• Microsoft Active Server Pages, version 1.0

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

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/support/vinterdev/

Additional query words:

Keywords          : kberrmsg kbAccess kbVisID100 kbGrpASP 
Version           : WINDOWS:1.0
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: May 11, 1999