Err Msg: Microsoft OLE DB Provider for ODBC Drivers error '80040e37' (197463)
The information in this article 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:
- Open Control Panel.
- Double-click the ODBC Control Panel extension to launch the ODBC
Administrator.
- Click the System DSN tab in the ODBC Administrator.
- Select the System datasource that is mapped to the Commerce Server
database.
- Click the Configure button to launch the Microsoft SQL Server DSN
Configuration wizard.
- Click the Next button twice.
- 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.
- Click the Next button twice, click Finish, and then click OK.
| Modification Type: | Major | Last Reviewed: | 6/29/2004 |
|---|
| Keywords: | kbprb KB197463 |
|---|
|