Execution of a FORWARD TO command from Sybase IQ to
Adaptive Server Enterprise using the ASEODBC driver fails with ASA
Error -660 “The identifier that starts
with ‘<identifier>’ is
too long. Maximum length is 28
.”
To avoid this problem, do one of the following after creating a remote Adaptive Server Enterprise server using either server class aseodbc or server class asejdbc and before executing a SQL statement that contains a string with double quotes against the remote server using the FORWARD TO statement:
Change the double quotes to single quotes
Include the database option SET QUOTED_IDENTIFIER OFF before the SQL statement to be executed:
FORWARD TO <remote server name> { SET QUOTED_IDENTIFIER OFF <SQL statement> }
Set the QUOTED_IDENTIFIER database option to OFF using a separate FORWARD TO statement:
FORWARD TO <remote server name> { SET QUOTED_IDENTIFIER OFF }