IBM Support

DSN name not found in DataStage .odbc.ini file when there is a "[" in a password field in a preceding DSN

Troubleshooting


Problem

A DataStage job on Unix using any of the ODBC stages fails with a "DSN name not found" error. Examination of .odbc.ini file shows the DSN name to be present and defined.

Symptom

Messages such as


Message: ss_PROS_CNTL:
The connector could not establish a connection to data source UAT using user dsadmuat.

Message: ss_PROS_CNTL: ODBC function "SQLConnect" reported: SQLSTATE = IM002: Native Error Code = 0:
Msg = [DataDirect][ODBC lib] Data source name not found and no default driver specified (CC_OdbcConnection::connect, file CC_OdbcConnection.cpp, line 578)

Cause

There is a "[" in a preceding DSN Password field

[MYDB]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss00.so
Description=DataDirect SQL Server Wire Protocol driver
Database=MYDB
LogonID=xyz
Password=abc[def
Address=nn.nn.nnn.nn,1433
QuotedId=No
AnsiNPW=No
EncryptionMethod=1

Environment

Unix with Progress Data Direct driver manager

Diagnosing The Problem

Temporarily remove the offending DSN and re test

Resolving The Problem

There is no need to hard code the user LogonID and Password entries, they can always be specified in your DataStage job. Having passwords hard coded in the .odbc.ini may also be against in house security policies.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"11.3;11.5;8.5;8.7;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21985582

Page Feedback