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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
77 | |
72 | |
48 | |
47 |
User | Count |
---|---|
160 | |
85 | |
80 | |
68 | |
66 |