Skip to main content
Question

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

  • 24 March 2022
  • 4 replies
  • 344 views

image

4 replies

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

Userlevel 6
Badge +16

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>

Userlevel 6
Badge +16

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

 

above mention link can't open.

 

image

Reply