Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase ASE Request SQLWays

Invalid Column Name Error In Trace File

Symptoms

After conversion process you may notice that some information that exists in the source may be missed in the generated results, for example default values in table. And in generated sqlways.trc file can be found an error message:
error 207, state ZZZZZ: [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Invalid column name 'text'.
error 207, state ZZZZZ: [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Invalid column name 'syscomments'.

Cause

It appears because in the ODBC driver setting is used “Use Quoted Identifiers” option. And queries to the system tables that are used to get information about the objects may not be executed correctly in the source database.

Solution

Uncheck the “Use Quoted Identifiers” option in the ODBC driver settings, like it is shown on the screenshot:


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase ASE Request SQLWays

sqlways/troubleshooting-guide/sybase-ase/export/invalid-column-name-error.txt · Last modified: July 02, 2021, 08:39:34 AM by alexandr.kirpichny
 
© 1999-2021, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement