Hi there,
I’m trying to connect (either via the Connect to Database activities in UiPath.Database.Activities or Invoke Code) to an IBM DB2 for LUW database. It requires an SSL cert, which I have in .jks form, and have converted each alias to its own individual .arm file using keytool; however, I do not have the password for the cert. I do have read-only login credentials for the database, though. I can successfully connect via DBeaver, but that is a Java-based application using JDBC. I’ve installed the IBM OLEDB driver - DB2COPY1. However, no matter what I try, either via Invoke Code or the Connect to Database activity, or the ODBC or OLEDB drivers, I cannot make a successful connection. I keep getting one of three errors, listed below.
Invoke Code:
Provider=IBMOLEDB.DB2COPY1;Hostname=<hostname>;Protocol=TCPIP;Port=<port>;Database=<database>;Uid=<uid>;Pwd=<pwd>;SecurityTransportMode=SSL;SSLServerCertificate=C:\Users\<user>\db2_client_uat5_db2.arm
Error: System.ArgumentException: Invalid argument
at IBM.Data.Db2.DB2ConnPool.ReplaceConnectionStringParms(DB2Connection connection, String szValue, DB2ConnSettings& pSettings, DB2ConnSettingsInternal& pSettingsInternal, Boolean bAttach, Boolean pushDownStrAppended)
Connect to Database activity:
Provider=IBMOLEDB.DB2COPY1;Hostname=<hostname>;Protocol=TCPIP;Port=<port>;Pwd=<pwd>;Uid=<uid>;Database=<database>
Error: Connect to Database: SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "", "". SQLSTATE=08001
Error (Through CMD, setting up the IBM CLI Driver config using db2cli validate -dsn alias -connect -user userid -passwd password):
[FAILED]: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: “SSL”. Communication API being used: “SOCKETS”. Location where the error was detected: “”. Communication function detecting the error: “sqlccSSLSocketSetup”. Protocol specific error code(s): “414”, “", "”. SQLSTATE=08001
Has anyone had any luck connecting to an IBM DB2 database from UiPath? I’ve already searched the forums as well as asked Gemini and Copilot to no avail. I am trying to keep this DSN-less, as it would require being set up individually each time when the robot is deployed to each computer.
Any help is appreciated. Thank you in advance!