Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: TNSNames error Post Reply Post New Topic
Author Message
LuckyJim1001
Newbie
Newbie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 2
Quote LuckyJim1001 Replybullet Topic: TNSNames error
    Posted: 13 Aug 2009 at 11:27pm
Hi all,

I am trying to connect to an Oracle database from CR 2008. It keeps saying there is a TNS error and cannot find the db.

Other apps are connecting fine (SQLPlus, Excel etc) just CR not.

Anyone know how CR knows where the tnsnames.ora file resides ?

I am thinking it might be a path problem but cannot check as our laptops are locked down so cannot edit the path.

Bit strange how other apps work though.

FYI I am connecting through the ADO driver.

Many thanks
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 14 Aug 2009 at 12:42pm
Do you have the Oracle ADO drivers installed?  (Not the Crystal ADO driver, the one from Oracle.)
 
Also, why are you using ADO instead of a native Oracle connection?  The native connection is faster and provides more features.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
LuckyJim1001
Newbie
Newbie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 2
Quote LuckyJim1001 Replybullet Posted: 15 Aug 2009 at 9:38am
What are the Orcacle native drivers ?

Apologies for being a newbie
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 16 Aug 2009 at 9:18am
In Crystal, when you're creating your connection, instead of going to ADO for your connection type, scroll down to Oracle and create an Oracle connection.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
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.020 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.