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. 01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated

01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated

Symptoms

"01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated."This error occurs when running a report using only the Natural account in the Row Format.

↑ Back to the top

Cause

The segments numbers loaded from Syteline were not in sequential order. Microsoft FRx requires that the segments be in sequential order from Syteline. For example, the segments cannot be numbered 1, 2, and 4, skipping number 3.

↑ Back to the top

Resolution

To resolve this issue, do the following:1. Modify the account structure in Syteline to add the missing segment. 2. Delete the *.g32 file(s) from the FRx sysdata directory. For information on how to find the sysdata directory, see HOWTO: How to Determine the Location of the SysData Directory (*** link to http://www.frxsoftware.com/FRxSoftware/LeftNav/Knowledgebase/FRx+Reporter/KB11346122002.htm). 3. Update any reports that use a full account in the row format to reflect segment 3.

↑ Back to the top

References

↑ Back to the top

Keywords: kb, misc_migrate_32718

↑ Back to the top

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