Microsoft KB Archive/214438

= ODBC Errors Occur with Oracle Using MSMarket =

Article ID: 214438

Article Last Modified on 6/29/2004

-

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

Keywords: kbprb KB214438

-

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

© Microsoft Corporation. All rights reserved.