9 Replies Latest reply: Aug 22, 2011 9:16 AM by Greta Van Driesche RSS

    odbc: error trying to get data from AS400  using a job.

      Hi

      If I run a qvw manually, I get information from AS400 without problems , but if I run the same qvw using a job in the Publisher , this error appears.

       

       

      33451322010-09-17 13:54:58NormalInformation
      17/09/2010 01:54:58 p.m.: Error: SQL Error:[Microsoft][ODBC Driver Manager] Data source name not found and no default


       

      I don't see the difference in the ODBC between User and System DSN defined in ODBC DATA SOURCE ADMINISTRATOR.

      What else should I check? It was functioning before, but it stop working. Does anyone have an idea to solve this connection problem?

      Many thanks