Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DB2 "Trigger Program" connect error

Good Morning,

 

I'm able to successfully connect via the built-in DB2 connector (using Microsoft driver, not IBM, and doing Import, not direct Query) to several files on our "DB2 server:Port;database" = "SYSB:446;SYSB".  However, some files throw an error:

 

DataSource.Error: Microsoft Db2 Client: Trigger program or external routine detected an error. SQLSTATE=38501 SQLCODE=-443 SQLSTATE=HY000 SQLCODE=-343
Details:
DataSourceKind=DB2
DataSourcePath=sysb:446;SYSB
Message=Trigger program or external routine detected an error. SQLSTATE=38501 SQLCODE=-443 SQLSTATE=HY000 SQLCODE=-343
ErrorCode=0

 

Has anyone run across this particular error having to do with "Trigger program or external routine"?  Any help is greatly appreciated!  Thanks so much...

 

Dave

 

Need Help

1 Reply

  • v-msft-pazhen's avatar
    v-msft-pazhen
    Frequent Visitor
    5 years ago

    Hi Anonymous ,

    What's the version of your Power BI Desktop and Microsft Driver? Could you please update them to latest one if they are not the latest version? And please review the following threads and check whether their solution can help you resolve the problem. Thank you.

    Power BI Direct query connection to IBM DB2

    IBM DB2 Connection

    Best Regards
    Rena
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.