Home Forums Reporting Services Reporting Services Report Manager DSN cannot connect to database. Help! RE: Report Manager DSN cannot connect to database. Help!

  • May 4, 2006 at 11:45 am

    #636057

    The error message is "

    • An error has occurred during report processing.

      • Cannot create a connection to data source 'dsJusticeData'.

        • For more information about this error navigate to the report server on the local server machine, or enable remote errors "
        •   
        •  
        •  
        •   The frustrating part about this is that I have EVERYTHING running on the same computer. SQL2005, ReportManager2005, VS2005, IIS and the ODBC is on the same computer. When I am designing the report in VS2005 I create a data source that uses the Informix ODBC and it connects and works fine. When I deploy the report to Report Manager (same computer) and set up a data source to the same ODBC connection I get the error. So in summary the data source using the Informix ODBC works when I am designing the report but does not work when the report is uploaded to Report Manager and uses the same Informix ODBC (all on the same computer).