Internal: IDL Dataminer error: "% OBJ_NEW: ODBC SQL Function=SQLPrepare,STATE=60,CODE=2711, [Exelis VIS][ODBC 20101 driver]2711"

PROBLEM:

The following error was encountered by a customer using IDL 8.2 on Linux, licensed for Dataminer, connected to an Oracle database using the IDL 8.2-provided DataDirect Oracle Wire Protocol ODBC driver, encountered the following error:

"% OBJ_NEW: ODBC SQL Function=SQLPrepare,STATE=60,CODE=2711, [Exelis VIS][ODBC 20101 driver]2711"

--when the same IDL program, database, and database connection had previously worked only a few days earlier.

The user had configured a local copy of the IDL 8.2 "odbc.ini" file, placed in the user's home directory tree, and with the location specified by an "ODBCINI" system environment variable in the shell used to start the user's IDL 8.2 Dataminer program.

POSSIBLE WORKAROUNDS:

1.) One possible workaround to this problem is as follows:

a.) Create/reconfigure a new local copy of the odbc.ini file from the template "odbc.ini" file provided in the IDL 8.2 installation, located at (by default):

/usr/local/exelis/idl82/resource/dm/linux.x86_64/odbc.ini

to replace your existing local copy of the odbc.ini file that is specified by your ODBCINI system environment variable.

b.) Give the new local copy of the configured odbc.ini file read-only privileges (e.g., chmod 400 odbc.ini).

2.) A second possible workaround would be:

a.) Create a backup copy of original "odbc.ini" file template located at

/usr/local/exelis/idl82/resource/dm/linux.x86_64/odbc.ini

naming the new copy "odbc.ini.orig" and leaving this backup copy in the original directory location.

b.) Then configure the IDL installation copy of the "odbc.ini" file leaving it in the original location.  Be sure the configured installation copy of the "odbc.ini" file has only read privileges for IDL users. 

The side effect of this change (workaround #2) would be that all IDL 8.2 Dataminer users running IDL from this IDL 8.2 installation will be able to read and access this shared "odbc.ini" file if they do not define an ODBCINI system environment variable to point to their own local configured copy of the IDL 8.2 "odbc.ini" file.

( Reference "CRID 67998" )