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

• Microsoft Site Server version 3.0, Commerce Edition

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.

Additional query words:

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