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

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

book

Article ID: 87881

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

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:
 

<Please see attached file for image>

0EMb0000001Qycs.png

Environment

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

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

Attachments

1558692819457000087881_sktwi1f5rjvs16lui.png get_app