Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Red face Unanswered: Crystal XI with Oracle 10.1.0.5

    Hi

    We are having all sorts of problems with an Oracle database connecting from Crystal Reports XI.
    if we connect through the Instant Client supplied ODBC driver, half the tables are not visible, some are under different users, and most of the views are not available for use.
    When we connect with the Oracle native connection that comes with Crystal, we can see the tables under the correct users and the views are available.

    The Problem is Crystal Reports is bringing back 0 records from the view, which when we run the exact same SQL in TSQL+ works fine and returns many records!

    Versions: Oracle Instant Client 10.1.0.4
    Oracle DB: 10.1.0.5

    I am installing the new Oracle Instant Client on a test server to see if that will fix the problem, but i doubt it.

    Any suggestions are greatly appreciated!

    Truby

  2. #2
    Join Date
    Feb 2009
    Posts
    1

    Any resolution to this?

    I'm having a similar problem, except do not have the Oracle Native driver!

    I have oracle client installed and CR XI R2 Developer.

    I DO have Oracle Server driver on another machine with CR XI R2 Standard and Business Object Enterprise plus Integration Kit for SAP.

    Thanks

  3. #3
    Join Date
    Oct 2007
    Posts
    2

    work around

    Hi,

    Yes, we switched a couple of things:
    1. installed the later version of the instant client
    2. changed to using an OLEDB connection rather than odbc

    everything works fine with that setup.



    Truby

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •