Print Page | Close Window

ODBC Connection for CR Reinstall

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9545
Printed Date: 04 May 2024 at 9:03pm


Topic: ODBC Connection for CR Reinstall
Posted By: jgarner
Subject: ODBC Connection for CR Reinstall
Date Posted: 30 Mar 2010 at 7:13am
I just had to reinstall my OS and applications including CR XI. When I was connected prior to the reinstallation, I had CR Oracle Driver 5.0 as a selection to choose from in the System DSN (Administrative Tools/ODBC Data Sourct Administrator). How do I get that driver to be listed as a selection when I click on the 'Add' button in the System DSN window?


Replies:
Posted By: kevlray
Date Posted: 30 Mar 2010 at 12:24pm
Do you have the Oracle client installed.  We just started using Oracle recently and did not see the option for Oracle before we installed the Oracle client.
 
I hope this helps.

Posted By: jgarner
Date Posted: 31 Mar 2010 at 9:22am
I did install the oracle enterprise odbc. (win32_11gR1_database_1013.zip) which is almost 2 gb to download. I'm not 100% sure if this is the one I used last time?.
 
If I remember correctly, I also had to include additional files (sqlnet.ora and tnsnames.ora) created in notepad, to be place in a specific folder. On another computer that currently has connectivity, the location is "C:\oracle\ora92\network\ADMIN", which is somewhat different than what was installed on my system with the above enterprise edition.

Posted By: jgarner
Date Posted: 31 Mar 2010 at 10:06am

Just noticed that the Oracle Enterprise edition I installed does not have the CR ODBC driver (in ODBC Data source Administrator/Drivers). It looks like I need to uninstall the Enterprise and find which Oracle software I need to install the CR driver.


Print Page | Close Window