Does 10.1B ODBC driver support the ability to query a table and specify an explicit NULL value in the results?
For example
Select
pub."table".field1 Code,
null SecondCode
from
pub."table"
when executing the above I get the following ODBC error
Syntax error in SQL statement at or about "null FROM pub."table" " (10713)
State:S1000,Native:-210056,Origin:[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]
Our solution has been to move off OpenEdge and onto Microsoft SQL Server 2008 r2.