ODBC Errors Occur with Oracle Using MSMarket (214438)

The information in this article applies to:

Microsoft Site Server 3.0 Commerce Edition

This article was previously published under Q214438

SYMPTOMS

One of the sample stores that ships with Commerce Server 3.0 (MSMarket) no longer works if you install MDAC 2.0, and then try to shop against an Oracle database. This previously worked with version 02.573.2620.0 of Msorcl32.dll, and continues to work with SQL Server 6.5 and 7.0.

The following messages may occur when you attempt to shop in the MSMarket store:

[Microsoft][ODBC driver for Oracle]Driver not capable

[Microsoft][ODBC driver for Oracle]Driver's SQLSetConnectAttr failed

CAUSE

Both "SQLSetConnectAttr" and "Driver Not Capable" in these two instances are not fatal errors. They are merely informational messages returned by ADO. They appear because of a change in functionality between ADO 1.5 and ADO 2.0.

WORKAROUND

To keep the messages from appearing, modify the error trapping in your ASP page.

MORE INFORMATION

For further information and examples on error trapping, see the following article in the Microsoft Knowledge Base:

214426 Unable to Complete Transaction in Market Sample Store

Modification Type:	Major	Last Reviewed:	6/29/2004
Keywords:	kbprb KB214438