Skip to Content
author's profile photo Ido Millet
0
Ido Millet

CR 2008 .NET Viewer App Failing on 2nd Data Retrieval from Oracle

Posted on Oct 14, 2010 at 12:07 PM 11 Views

The Viewer application is a .NET VS2008 CR2008 SP3 viewer application.

Data source: Oracle via ODBC (same problem with both 'Oracle in OracleClient10203' as well as 'CR Oracle ODBC Driver 5.3).

The problem occurs only upon refresh. In other words, only after data retrieval has been done once.

By using ODBC tracing, we found that on the first data retrieval the View used by the report was qualified (in the SELECT FROM... statement) and the report ran fine. However, on the second call the qualifier was stripped causing a failure to locate the Oracle View.

Same report using Crystal XI R2 RDC Viewer runs and refreshes fine, so I suspect the problem is in the Crystal 2008 runtime components.

Is this a known issue?

- Ido

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Don Williams
    Don Williams
    Posted on Oct 14, 2010 at 01:29 PM
    0

    Hi Ido,

    Moved to the .NET SDK forum. I assume this all works in CR Designer?

    Not that I've seen. What does your logon code look like? Any subreports and are you looping through and logging them on also?

    When you say second call are you using the Viewers refresh button or your own?

    Thanks

    Don

    Add a comment
    10|10000 characters needed characters exceeded

    • Ido Millet Don Williams
      Oct 14, 2010 at 02:27 PM

      Thanks, Don.

      The connection upon Refresh doesn't fail. What causes the failure is the attempt to SELECT from a View name that is no longer qualified. On first connect, the SQL statement passed to the server contains a ... FROM "Qualifier.View_Name".

      On refresh, the SQL statement passed to the server contains only ... FROM "View_Name". Note how the Qualifier disappears.

      I still think this is a problem in the runtime components and not in my code but if that is true, sooner or later someone will report the same problem... 😊

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.