Created On:  12 January 2011


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

For example:


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


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.