Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Contact
Find Answers
Join Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Get Support
Have a Question?
Search Qlik's Support knowledge database or request assisted support for your highly complex issues.
Submit a Case
Talk with a Representative
Critical Issues
Experiencing a business critical issue? Please Contact us by phone. Click here to view phone numbers by region.
Contact UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
- ALERT: Qlik Product Download Page Click here
- ALERT: Support Alert Click here
Knowledge
SQL1531N Error for DB2 Connector
Article Number: 000063807 | Last Modified: 2020/01/08Description
When trying to configure a DB2 connection, the following error message appears:
SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2.cli.ini configuration file. Data source name specified in the connection string: <data source name>
Environment:
SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2.cli.ini configuration file. Data source name specified in the connection string: <data source name>
Environment:
- Qlik Sense Enterprise - any version
- Qlik Sense Desktop - any version
Cause
Configuration issue with the IBM DB2 driver. If additional assistance is required, please contact IBM for support.
Resolution
This is not a Qlik Sense configuration issue. It is a configuration issue with the driver itself. This article offers guidance per the IBM Support site. If additional assistance is required, please contact IBM for support.
Source: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.messages.sql.doc/com.ibm.db2.luw.messages.sql.doc-gentopic5.html#sql1531n
The db2dsdriver.cfg configuration file contains database directory information and client configuration parameters for use by some IBM data server clients and drivers.
The CLI/ODBC initialization file (db2cli.ini) contains various keywords and values that can be used to configure the behavior of CLI and the applications using CLI.
This message is returned when a data source name is specified in a connection string with the "DSN" connection keyword but the specified data source name cannot be found in either of the following locations:
- Specified with the "dsn alias" configuration keyword in the db2dsdriver.cfg configuration file
- Specified as a section header in the db2cli.ini configuration file
Solution:
- Add the specified data source name to the db2dsdriver.cfg configuration file or the db2cli.ini configuration file.
- Stop and restart the application process for the new configuration settings to take effect.
- Resubmit the connection request to the specified data source name.
Note: Qlik does NOT support the configuration or implementation of non-Qlik software.
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.