Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Error Message:
DataSource.Error: IBM DB2: ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "SSL". Communication API being used: "SOCKETS". Location where the error was detected: "SOCKETS". Communication function detecting the error: "sqlccSSLSocketSetup". Protocol specific error code(s): "420", "*", "*". SQLSTATE=08001
Details:
DataSourceKind=DB2
DataSourcePath=dsn01p.db.bnsf.com:55000;dsn01p
Message=ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "SSL". Communication API being used: "SOCKETS". Location where the error was detected: "SOCKETS". Communication function detecting the error: "sqlccSSLSocketSetup". Protocol specific error code(s): "420", "*", "*". SQLSTATE=08001
ErrorCode=-2147467259
@Anonymous , Make sure you have .net driver installed. Also you can clear permission in data source setting and try again
also refer
https://community.powerbi.com/t5/Power-Query/IBM-DB2-Connection/m-p/84746
@amitchandak :Could you please give me full name of the software and version aslo kindly help me
@Anonymous , refer
https://www.ibm.com/support/pages/download-initial-version-115-clients-and-drivers
refer prerequisites
https://docs.microsoft.com/en-us/power-query/connectors/ibmdb2database#prerequisites
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |