when connecting to Db2 on AS/400 from win2k through odbc i get 

[Microsoft][ODBC Driver for DB2][Microsoft DB2 OLE DB Provider]DDM /
DRDA Agent is not loaded or unreachable.,
SQL state S1000

for past several years it used to work just fine, now we have this
problem is there any workoround for this problem

---

Clarification of Question by almir_kazazic-ga on 08 Jul 2002 09:33 PDT

interesting part is when i test odbc-source the application works
fine for several hours, odbc starts functioning , but after a while it
stops, and if i test ODBC DNS again, which does not have to be the one
I am using but the one with same parametars , but other DNS entry,
both of them start functioning  and are working for a WHILE

You probably know all this already, but just in case:

Perhaps your DDM/DRDA listner on the AS/400 is no longer configured to
start automatically?

You can let it start whenever TCP/IP is started by using:
CHGDDMTCPA AUTOSTART(*YES)

or start it manually:
STRTCPSVR SERVER(*DDM)

If that's not the problem, there might be a connection problem. Can
you ping the AS/400 from you Windows machine?

kind regards,

rhansenne-ga.

thank you, 
honestly I have heard for DDM/DRDA for the first time now, i never
worked with this machines, in fact i made only web interface for that,
which is talking to as/400 db2  through odbc.
 interesting part is when i test odbc-source the application works
fine for several hours, odbc starts functioning , but after a while it
stops, and if i test ODBC DNS again, which does not have to be the one
I am using but the one with same parametars , but other DNS entry,
both of them start functioning  and are working for a WHILE

a.