Created On:  12 January 2011

Problem:

AcuSQL Version 8.x gives an “Invalid column name” error if the WHERE clause uses double-quotes around the value.

For example:

     WHERE COLUMN-1 = "ABC"

This worked without error in Version 7.x but in 8.x the select fails with the error "Invalid column name".

Resolution:

AcuSQL for SQL Server version 8.0 changed the communication technology used to access SQL Server, from dblib to ODBC. This is due to the fact that dblib had been discontinued by Microsoft and was no longer supported. ODBC requires single quotes around string values, where the old dblib allowed double quotes.  This is a permanent restriction.

To resolve the error modify the ESQL in the COBOL program to use single quotes around the WHERE value.