ODBC Errors Occur with Oracle Using MSMarket

• Microsoft Site Server version 3.0, Commerce Edition

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:

Q214426 Unable to Complete Transaction in Market Sample Store

Additional query words:

Keywords :
Version : winnt:3.0
Platform : winnt
Issue type : kbprb