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

Article translations Article translations
Article ID: 966151 - View products that this article applies to.
Expand all | Collapse all

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.

CAUSE

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

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 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.


Properties

Article ID: 966151 - Last Review: January 27, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
  • FRx Financial Reporter 6.5
Keywords: 
KB966151

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com