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 [Microsoft][SQL Native Client][SQL Server] Invalid Object Name Frl_Acct_Code

Run-Time error -2147217865 [Microsoft][SQL Native Client][SQL Server] Invalid Object Name Frl_Acct_Code

Symptoms

Run-Time error -2147217865
[Microsoft][SQL Server]Invalid object name 'frl_acct'_code'

Trying to create a new row using Add Rows from Chart of Account.

↑ Back to the top

Cause

This error is caused by two different things.



  • The Ross SQL Server Database is case sensitive and FRx views need to be created

    OR
  • The Data Source for FRx 6.x was created using SQL Native Client

↑ Back to the top

Resolution

  • Run views_frx.sql. This script creates views to the frl tables for case sensitive servers.
    To run the Sql Server script, open the script in the Query Analyzer Window and generate it against the database.

    The script can be found on our website www.frxsoftware.com , under Support >> Service pack >> Check for availability of Service Packs for your general ledger >> SQL Scripts


    NOTE: Running the script should be done by the Database Administrator. Create a back up of the Ross Database before running the script. User should not be working in FRx or Ross application while running the script.

    OR
  • Delete the Data Source that was created with the SQL Native Client
    Create a new Data Source using SQL Sever 2000 driver

↑ Back to the top

References

↑ Back to the top

Keywords: kb, misc_migrate_32718

↑ Back to the top

Article Info
Article ID : 966150
Revision : 5
Created on : 4/13/2018
Published on : 4/13/2018
Exists online : False
Views : 71