• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 812
  • Last Modified:

ODBC error

Hi,
I am running broadcast agent on an NT server. When I try to run a report, I get the following error.

(109) connection or sql sentence error (da0005)
[ibm] client access driver (32-bit)(db2/400 sql) communication link failure. COMM RC=0*5-5.
The following providers have not been succesfully refreshed: Query 1 with COM_PROD(DMA0007).

Can any one help me with this.

Thank you,

Shelmina
0
Shelmina_Shivji
Asked:
Shelmina_Shivji
1 Solution
 
Shelmina_ShivjiAuthor Commented:
Make sure the username and the domain is the same as the one used when installed ODBC on the server. Also in the Data SOuce Names check if the connections are set properly.
0
 
GhostModCommented:
PAQed, with points refunded (30)

GhostMod
Community Support Moderator
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now