Skip to main content
Question

I'm tring to connect database of IBM DB2 but not showing the db2 database option in database type.?

  • March 24, 2022
  • 4 replies
  • 526 views

image

4 replies

  • Author
  • Cadet | Tier 2
  • March 24, 2022

@Arup Mitra​ , Any one are available for given me solution of this above mention problem?


Forum|alt.badge.img+22
  • Most Valuable Pathfinder
  • March 24, 2022

Hi @Dilshad Syed Bukhari​ ,

 

Checkout below KB for establishing a connection to IBM DB2 Database,

 

https://apeople.automationanywhere.com/s/article/How-to-connect-IBM-DB2-database-in-A2019/p>


Forum|alt.badge.img+22
  • Most Valuable Pathfinder
  • March 29, 2022

Hi @Dilshad Syed Bukhari​ ,

 

Checkout below content from the KB,

 

TitleHow to connect IBM DB2 Database in Automation 360?

QuestionHow to connect IBM DB2 Database in Automation 360 (formerly Automation Anywhere Enterprise A2019)?

Answer- Use the below connection string using Connect command:

Provider=IBMOLEDB.IBMDBCL1;Password=*****;User ID=****;Data Source=****;test=.xml

 

- If you are using the IBM BD2 ODBC DRIVER then use the below connection string into the Connect Database command. (Place the Database name, Hostname, Port, Uid, Password into the below sample Connection String)

 

Driver={IBM DB2 ODBC DRIVER};Database=databasename;Hostname=*********.com:50001;Protocol=TCPIP;Uid=e006*;Pwd=*****;test=.xml

Additional InformationRefer below KB article steps to install  IBM DB2 32-bit ODBC driver.

https://apeople.automationanywhere.com/s/article/How-to-install-IBM-DB2-ODBC-32-bit-driver

 


  • Author
  • Cadet | Tier 2
  • March 29, 2022

above mention link can't open.

 

image