Skip to Content
author's profile photo Former Member
Former Member

Oracle Native Driver issue in Crystal Reports XI R2

I have installed Oracle 10g express on my machine. I have Crystal Reports XI R2. working on XI R2 from Jan. I would like to use Oracle Native driver connection because I need to create a report using a stored procedure which has an IN OUT Ref cursor. I am able to see Oracle from the crystal report data expert. But when I right click on Oracle for a new connection.....all the options like Add to Report, Add to Favorites, Add command to Report, Make a new connection .... so on are disabled. When I double click on oracle the crystal is looking for some msi file and throwing an error installation package is unavailable. when I point it to the correct msi file path, displaying a message not a installation package. I have only one crystal msi file on my machine.

Does it mean, Oracle is not properly istalled? Please advice.. I need the solution very urgently.

Your help is greatly appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2010 at 01:48 AM

    Hi Shyam,

    I had a similar problem when we upgraded a couple of machines to CR IXr2 from r1. It seems that r2 doesn't install all the drivers automatically. We had to reinstall r2, and go for the advanced install, and install all components.

    hope this helps.

    Aaron

    Add a comment
    10|10000 characters needed characters exceeded

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.