Home > Crystal Reports > Crystal Reports Error Ora-12154

Crystal Reports Error Ora-12154

Contents

Thanks for your help Report message to a moderator Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #600832 is a reply to message #492689] Basically, If error says that tns name cant be found, this is what you should look into. Oracle guys should come out with a definitive answer. Because I'm using the Instant Client, I cannot run TNSPING, as there's no TNSPING shipped with the instantclient. Check This Out

If this is missing from tnsnames.ora, you will see: ERROR: ORA-12154: TNS:could not resolve service nameError description says it all :) 12154, 00000, "TNS:could not resolve service name" // *Cause: The If so, try to install it into another directory (I'd suggest "c:\crystal"). What if the ping works, the tnsping works, the SQL (xe) works but still you get the error? Huffman compressor in Java My boss asks me to stop writing small functions and do everything in the same loop Find the "Recursive Size" of a List more hot questions question https://scn.sap.com/thread/3358686

Sap Kb 0001198150

Your Email This email is in use. I checked the tnsnames.ora file and sqlnet.ora file. Like Show 0 Likes(0) Actions 57.

Ahhhh, that nudged a memory we had a somewhat similar unexplainable connection problem on 64 bit Windows. I am not a dba but I have loaded oracle 7, 8 and 9 many times, always with the default orcl instance, and always it worked fine. Only “Administrator” or a “Custom” installation with all the required modules selected would work.

NOTE: This will allow you to create and run the package successfully from BIDS, Try enclosing the connect identifier in quote marks.

Some components may not be visible. Ora-12154: Tns:could Not Resolve The Connect Identifier Specified So..... Thanks a lot in advance, Alexander Like Show 0 Likes(0) Actions 50. http://www.dba-oracle.com/t_failed_open_connection_database_%20vendor_code_12154.htm For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository

Is a world with two different types of air possible? If required, you should do a custom installation of Oracle Client tools and select the appropriate Windows Interface as in the figure below:

IF the When answering a question please: Read the question carefully. Regards, Permalink Posted 28-May-13 4:25am Prasad Khandekar51.8K Add a Solution Add your solution here B I U S small BIG code Plain TextC++CSSC#Delphi / PascalF#HTML / XML / ASPJavaJavascriptObjective-CSQLSwiftPerlPHPPythonVBXMLvar

Ora-12154: Tns:could Not Resolve The Connect Identifier Specified

My back end is Oracle 10g and VB.NET as front end. http://www.devshed.com/c/a/Oracle/Experience-the-Possibilities-with-Oracle-10g-Express-Edition/ For other tutorials on Oracle check out this link: http://www.angelfire.com/vt2/hodentek/ It's a shame so many people have to spend so much time trouble shooting this ORA-12154 error. Sap Kb 0001198150 Now with 10.2.0, I find I am in the same situation as others here. Is it not time to clarify the situation by means of an extended trouble shooting page.

there are only two things(client-side) that can cause that error given that your SQL Client is connecting:1. http://digitalezines.com/crystal-reports/crystal-reports-error-ufl.html It points to a directory, where I've got a TNSNAMES.ORA file. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 3 4 5 6 Previous Next 84 Replies Latest reply on Aug 4, 2010 1:51 Re: ORA-12154: TNS:could not resolve the connect identifier specified 540384 Apr 23, 2007 8:27 AM (in response to 523988) I can confirm this.

What's wrong on the Windows side? Errors in a TNSNAMES.ORA file may make it unusable. –k1j May 8 '15 at 9:49 add a comment| active oldest votes Know someone who can answer? Optional Password I have read and agree to the Terms of Service and Privacy Policy Please subscribe me to the CodeProject newsletters Submit your solution! this contact form Errors in a TNSNAMES.ORA file may make it unusable If you are using directory naming: Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the

We run lots of crystal reports(1000's) that pull data from an oracle back end. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. Like Show 0 Likes(0) Actions 53.

Action: Make the following checks and correct the error.

They could be perfectly adequate. It depends on your specific installation(s) and configuration. General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ Author : Debarchan(MSFT) , SQL Developer Engineer , Microsoft Reviewed by : Smat (MSFT) , SQL Escalation Services, Microsoft Tags Native Data Access Technologies NONSSIS OLEDB Oracle Comments (10) Cancel reply

Like Show 0 Likes(0) Actions 56. Hope this helps Thanks Santhosh Like Show 0 Likes(0) Actions 55. Some components may not be visible. navigate here Why do most of us wear wristwatches on the left hand?

Details: Database Vendor Code: 12154, refers to the TNS error ORA-12154: TNS-12154 TNS: Could not resolve service nameCause: The service name specified is not defined correctly in the TNSNAMES.ORA file. Terms of Service Layout: fixed | fluid CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100 Members Search Help Register Login Home Home» SQL & PL/SQL» Client It's frustrating... Re: ORA-12154: TNS:could not resolve the connect identifier specified 509395 Aug 4, 2006 2:33 PM (in response to orafad) That's an answer, but not a good one.

Thanks for this- Littlefoot [Updated on: Tue, 12 November 2013 21:08]Report message to a moderator Previous Topic: ORA-01031: insufficient privileges Next Topic: & and SET DEFINE Instance "oracle10gr2", status READY, has 1 handler(s) for this service... Like Show 0 Likes(0) Actions 58. ERROR: ORA-12154: TNS:could not resolve service name Enter user-name: ^CInstead of $Password, I wrote the correct password, of course.

AS I am new to this I have absolutely no idea how check it. Look for unmatched parentheses or stray characters. says: November 18, 2011 at 11:48 am Resolveu minha vida com a utilização do windows 7 x64. This tool uses JavaScript and much of it will not work correctly without it enabled.

See more: VB VB.NET Hello, I am doing a project and in that project i need to incorporate reports so am using crystal report. Let's wait for Hux comments as well. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming. Do you need your password?

That is absolutely correct, the oracle driver looks to TNSNames.ora for the database information. | Post Points: 5 haahoou Lahore Since 10/4/2003 Posts 260 Reputation 4,255 Reply hehe hehehe (haahoou) replied Data source name: bbpdwhp4.