Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Run-time error '-2147217865 (80040e37)': [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'frl_acct_code'.

Run-time error '-2147217865 (80040e37)': [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'frl_acct_code'.

Symptoms

"Run-time error '-2147217865 (80040e37)':
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'frl_acct_code'."

This error occurs while adding an account to a new row format in FRx Designer or when trying to log into a company.

↑ Back to the top

Cause

Scripts have not been run against the Epicor Database or the user does not have proper rights to the database.

↑ Back to the top

Resolution

If this is a new Epicor Database then Database Scripts will need to be run against the database. These scripts can be found on the Epicor CD or at www.FRxSoftware.com in the Service Pack download area for Epicor. Microsoft FRx users will also need to have db_datareader rights to the Epicor Database in SQL Server.

We recommend that a full database backup is performed and a Database Administrator perform any database tasks like running Scripts or modifying Security.


↑ Back to the top

References

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 966151
Revision : 6
Created on : 9/2/2020
Published on : 9/2/2020
Exists online : False
Views : 79