1 2 Previous Next 26 Replies Latest reply: Jun 27, 2012 10:11 PM by dc NameToUpdate RSS

AIE DB2 adapter issue

dc NameToUpdate

We are on 764patch2 (ARS/Atrium/ITSM) in a windows environment.

 

We are trying to use AIE's DB2 adapter to pull data from DB2 tables.

 

From the command prompt, when we run the below command, it throws error

 

*************

D:\Program Files\BMC Software\AtriumCore\aie\service64\bin>db2helper -ax <AR Server> -ar <PORT> -al <RemedyAdminLogin> -ap <RemedyAdminPwd> -da <DB2ALias> -dl <DB2User> -dp <DB2UserPwd> -di <DB2Instance> -t

 

ERROR ***
Connection to DB2 database failed:[Microsoft][ODBC Driver Manager] Function sequ
ence error

Failed to Connect to DB2 Database

*************

 

1 The DB2 Client is installed on the server where AIE is installed

2 We are able to login to DB2 using the Db2 client with the details used in the above command (Which proves that the Db2 client & the credentials are fine)

3 Same Db2 client (but a 32Bit version) is installed on a 7.1 AIE server  where this works fine.

 

we are in the proces of upgrading AIE from 71 to 764 patch2 and the issue is coming..

 

Has anyone seen this?

 

Thanks

1 2 Previous Next