IBM Support

SQLCODE -1001 error when connecting to DB2 from non-z/OS Unix installation.

Troubleshooting


Problem

When attempting to connect to DB2 from my remote Modeler server located on a Unix platform I get the following error. SQLDriverConnect failed :[DataDirect][ODBC DB2 Wire Protocol driver][DB2]Unkown error: SQLCODE -1001 How can I fix this?

Resolving The Problem

The default odbc.ini is a template for future datasource connection information. In the case of DB2 it has entries appropriate for DB2 on z/OS as well as other platforms. If you are connecting to a non z/OS platform, then you must comment these properties out. If instead you are connecting to DB2 on z/OS you need to supply valid property values.


Please edit your odbc.ini file to simply comment out these two lines in the datasource configuration:

This:

#Collection applies to z/OS and iSeries only
Collection=

needs to be this:

#Collection applies to z/OS and iSeries only
#Collection=


and this:

#Location applies to z/OS and iSeries only
Location=<location_name>

needs to be this:

#Location applies to z/OS and iSeries only
#Location=<location_name>

[{"Product":{"code":"SS3RA7","label":"IBM SPSS Modeler"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Modeler","Platform":[{"code":"PF002","label":"AIX"}],"Version":"14.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

90556

Document Information

Modified date:
16 June 2018

UID

swg21488770

Page Feedback