I actually got by this error and I am stuck on another. I changed the script to the below.
Driver=IBM DB2 ODBC DRIVER - DB2COPY1;Server=FMS;Database=DNSP;ConnectTimeout=0;Interrupt=0;User Id=Cxxxxxx;Password=xxxxxx;
I get ==> ERROR [08001] [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "127.0.0.1". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001
I went to my Firewall and added rules for studio.exe as well as all the port # for my connection. How do I get around this error?
------------------------------
Anthony Gadzinski
------------------------------
Original Message:
Sent: Wed June 23, 2021 11:57 AM
From: Anthony Gadzinski
Subject: How do I set-up a DB Connection in RPA Studio 20.12.5
Hello Hello,
I have my DB connections set-up in QMF as well as DB2 for SPSS. How do I set-up the same DB connections I use in these tools in RPA Studio. I watched the videos and searched in Google but none of my connection strings work.
For example, I tried an ODBC Connection as Server=jdbc:db2://warehouse.data.zc2.ibm.com:50001;Database=bludb;User Id=a_ibm_com;Password=xxxxxxxx and I get the message "ERROR [IM002] Microsoft ODBC Driver Manager Data Source name not found and no default driver specified.
Does anyone have a step-by-step instructions to connect to bludb in CEDP?
Thank you.
------------------------------
Anthony Gadzinski
------------------------------