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
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
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.
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.
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.
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.