Print Page | Close Window

TNSNames error

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=7373
Printed Date: 28 Apr 2024 at 5:04pm


Topic: TNSNames error
Posted By: LuckyJim1001
Subject: TNSNames error
Date 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


Replies:
Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: LuckyJim1001
Date Posted: 15 Aug 2009 at 9:38am
What are the Orcacle native drivers ?

Apologies for being a newbie

Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window