ODBC Connection to AS400

thumsup9 · Post by **thumsup9** » Mon Jul 31, 2006 9:35 am

Hi All,

Each developer logs on to DataStage client with their own profile. Then they connect to AS400 using ODBC with a generic profile which all developers can use. I am unable to connect to AS400 while others can.Is there an issue with my profile to connect to DataStage as I cant see an issue with the generic profile for AS400 which everyone can connect and get the data. Or is there any other issue that you can think of ?

Any inputs appreciated,

Thanks,

thumsup9 · Post by **thumsup9** » Mon Jul 31, 2006 9:47 am

I just got a breakthrough. I had a connection open to AS400 which was not killed and I was trying to view the data again and again which made it worse. I had to close my DataStage client and then kill all the connections I had to AS400 and then try and it worked.

Thanks,