Forum Discussion
DB2 error: SQL0204N...is an undefined name
For people that still get this error when trying to connect via IBM Driver…
"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): "410", "", "". SQLSTATE=08001"
My solution was manually disabling encryption for my Data Source in Power BI which resulted in another error message:
"An error happened while reading data from the provider: 'The type initializer for 'Microsoft.HostIntegration.Common.TelemetryCLient' threw an exception.'"
This error only seems to occur when Microsoft’s DB2 OLEDB driver is installed on the same system as Power BI Desktop. For people who don’t have this driver installed step 1 might already fix the error.
For a fix/workaround of the second error look at the last posts in this thread:
https://community.powerbi.com/t5/Issues/DB2-support-Default-driver-not-working/idi-p/715435