VARA.SQL and VARA.SQLI delivers no result on on system, and a result on another

Document ID : KB000087881
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
If the same VARA.SQL or VARA.SQLI gives results in one system and no results in another, please check in Microsoft ODBC Administrator if if both options are checked like in the screenshot below:
 
0EMb0000001Qycs.png
Cause:
Cause type:
Configuration
Root Cause: Both options must be checked.
Resolution:
Make sure both "Use ANSI quoted identifiers" and "Use ANSI nulls, paddings, and warnings" options are checked in Microsoft ODBC Administrator.

Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A