Microsoft KB Archive/197463

= Err Msg: Microsoft OLE DB Provider for ODBC Drivers error '80040e37' =

Article ID: 197463

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Site Server 3.0 Commerce Edition

-



This article was previously published under Q197463



SYMPTOMS
When you attempt to manage a Microsoft Commerce Server site through the Site Server Service Admin HTML Manager interface, the following error may occur:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name



CAUSE
This error can occur when the Commerce Server Data Source Name (DSN) has no default database specified or when the default database specified is a database other than the database containing the Commerce Server tables.



WORKAROUND
When you set up the DSN, you need to change the default database to the database that contains all of the Commerce Server tables. If the "Change the default database to:" option is left unchecked or points to a database other than the one that contains the Commerce Server tables, the above error will occur.

To change the default database for the Commerce Server DSN to the correct database, do the following:
 * 1) Open Control Panel.
 * 2) Double-click the ODBC Control Panel extension to launch the ODBC Administrator.
 * 3) Click the System DSN tab in the ODBC Administrator.
 * 4) Select the System datasource that is mapped to the Commerce Server database.
 * 5) Click the Configure button to launch the Microsoft SQL Server DSN Configuration wizard.
 * 6) Click the Next button twice.
 * 7) On the third page of the wizard, click the "Change the default database to:" checkbox, and then click on the dropdown list to select the Commerce Server database.
 * 8) Click the Next button twice, click Finish, and then click OK.

Keywords: kbprb kbfaq KB197463

-

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

© Microsoft Corporation. All rights reserved.