Skip to Content
avatar image
Former Member

Reg: Crystal Report in CMC

Hi All,

I need to connect Access db to the Crystal Report.For that I created one ODBC Connection in System DSN.Using ODBC connection I designed a Crystal Report .That Report is working fine in Crstal Report.But if I open the Report in CMC ,It is showing the following Error.

Error

Failed to open the connection. XXX.rpt

What could be the reason for that?

Thanks & Regards,

Hemalatha J

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 15, 2009 at 03:11 PM

    Did you define the DSN on the CMC server, and does that server have access to the Access DB?

    HTH,

    Carl

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2009 at 10:03 PM

    Hi Hemalatha,

    Check with the System DSN connection created at the back end ODBC data sources.

    Then test the connection of the DSN you have created.If it works fine then open report in crystal reports.

    Go to the Database Tab in crystal designer and select Set Data source Location option.

    Then you can update the connection of the report.

    Click on Create a new connection not the existing connection and point to the same DSN connection.

    Create the report ODBC or OLEDB connection type and update the connection.

    Then try to republish the report to enterprise after updating the report connections.

    Then open the report in CMC and view the report.

    Thanks,

    Naveen.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 20, 2009 at 04:10 PM

    Hi Hemalatha,

    Let us know whether the below steps were helpful or there any errors you are facing:

    Check with the System DSN connection created at the back end ODBC data sources.

    Then test the connection of the DSN you have created.If it works fine then open report in crystal reports.

    Go to the Database Tab in crystal designer and select Set Data source Location option.

    Then you can update the connection of the report.

    Click on Create a new connection not the existing connection and point to the same DSN connection.

    Create the report ODBC or OLEDB connection type and update the connection.

    Then try to republish the report to enterprise after updating the report connections.

    Then open the report in CMC and view the report.

    If the issue is solved, close this thread.

    Thanks,

    Naveen.

    Add comment
    10|10000 characters needed characters exceeded