Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: ODBC Connection for CR Reinstall Post Reply Post New Topic
Author Message
jgarner
Senior Member
Senior Member


Joined: 23 Jan 2009
Location: United States
Online Status: Offline
Posts: 159
Quote jgarner Replybullet Topic: ODBC Connection for CR Reinstall
    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?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
jgarner
Senior Member
Senior Member


Joined: 23 Jan 2009
Location: United States
Online Status: Offline
Posts: 159
Quote jgarner Replybullet 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.
IP IP Logged
jgarner
Senior Member
Senior Member


Joined: 23 Jan 2009
Location: United States
Online Status: Offline
Posts: 159
Quote jgarner Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.