ODBC connection error [DataDirect][ODBC OpenAccess SDK driver] [OpenAccess SDK SQL Engine]Input to loadExternalStrings() is invalid

Document ID : KB000129141
Last Modified Date : 12/03/2019
Show Technical Document Details
Issue:
On our CABI BOXI server, we had installed the ODBC drivers for CA Service Desk Manager. When we try to connect from the ODBC console, the connection fails with the following error:

[DataDirect][ODBC OpenAccess SDK driver] [OpenAccess SDK SQL Engine]Input to loadExternalStrings() is invalid

We had installed the drivers from CA SDM installation disk. Re-installng the drivers does not resolve the issue.
Environment:
CA Service Desk Manager 14.1
CA Service Desk Manager 17.1
Cause:
CA SDM assumes that a webengine in the environment is named pdmweb.exe.
However, CA SDM can be configured such that pdmweb.exe is either not used or it is used as the name of the web director.
Resolution:
Set a new environment variable in the NX.env file so that the CA SDM ODBC driver knows that pdmweb.exe is not being used as the name of the default webengine of the default domsrv.

To do that, the "NX_PDMWEB_RENAMED_TO" environment variable needs to be set to the webengine executable of the default domsrvr.  For example, "pdmweb1.exe" as per the following instructions:

1. Run: pdm_options_mgr -c -s PDMWEB_RENAMED_TO -v <webengine_executable_name> -a pdm_option.inst
where <webengine_executable_name>' is the name used in place of 'pdmweb' .

For example: pdm_options_mgr -c -s PDMWEB_RENAMED_TO -v pdmweb1 -a pdm_option.inst

2. To avoid losing the change whenever you run pdm_configure, please run the above command with the '-t' flag as follows:
pdm_options_mgr -c -s PDMWEB_RENAMED_TO -v <webengine_executable_name> -a pdm_option.inst -t
where <webengine_executable_name> is the input name used in place of 'pdmweb'.
 
For example: pdm_options_mgr -c -s PDMWEB_RENAMED_TO -v pdmweb1 -a pdm_option.inst -t

3. A Service Desk product recycle is normally needed for the new NX variable to take effect.
After the recycle, verify NX.env still includes this statement: @NX_PDMWEB_RENAMED_TO=pdmweb1
Additional Information:
The following knowledge article suggests the same solution:
Error: RegQueryValueEx Unable to connect: Socket open error on pdmweb.exe - (605), (IES 10901) (Error; INF)