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 '-2147217900 (80040e14)

Run-time error '-2147217900 (80040e14)

Symptoms

Run-time error '-2147217900 (80040e14)':[Microsoft][ODBC SQL Server Driver][SQL Server]The query uses non-ANSI outer join operators ("*=" or "=*").

To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN).

In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes

This error occurs in any one of the following three instances:
  1. FDM 6.0 and 7.0 - Error in GL Zoom in row format against SQL 2005 database.
  2. FRL13, FDM 6.0 and 7.0 - Error launching Report Wizard against a SQL 2005 DB.
  3. Reports with Reference Codes, TREF, TPROJ receive error against SQL 2005 DB.

↑ Back to the top

Status

This SMR has been fixed in R07670 Service Pack and subsequent Service Packs, please check or website (www.FRxSoftware.com) for availability of Service Packs for your General Ledger. You may also sign up for automatic notification of Services on our website .

↑ Back to the top

Workaround

To work around the issue, do the following to set the Compatibility Level of the Database to 80:
  1. In Enterprise Manager, right click the database. Select Properties.
  2. Select the Options Tab.
  3. Change the Compatibility Level to 80.

↑ Back to the top

References

↑ Back to the top

Keywords: kb

↑ Back to the top

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