Crystal Reports Error Ora-12154
Contents |
SAP Crystal Reports, version for Visual StudioWhere is this place located?All Places SAP Crystal Reports, version for Visual Studio 15 Replies Latest reply: Jan 22, 2013 3:33 PM by Andrew error while trying to retrieve text for error ora-12154 Paes Tweet Crystal Reports Windows Server 2008 ORA-12154: TNS:could not resolve the ora 12154 error in oracle 11g connect identifier specified Andrew Paes Jan 10, 2013 8:59 PM Currently Being Moderated Hi,I can't connect my ora 12154 error solution report and the error showed is:ORA-12154: TNS:could not resolve the connect identifier specifiedBut, other App in the same environment could connect withou problems. So, the Oracle Client is working ora 12154 error in toad fine and TNSNAMES are well configured.In my dev machine I can connect the same database without errors. I don't know what could be different about the environment.#######################Dev pc- Windows Enterprise 7 32 bits;- SAP Crystal reports version for Visual Studio 2010 ( CRforVS_13_0_4 );- Oracle client 11;Server configuration is:- Windows Server 2008 Standard SP2 64 bits;- SAP Crystal
Ora 12154 Tns Error
reports runtime engine for .Net Framework 4 (64-bit) ( CRforVS_redist_install_64bit_13_0_1 );- IIS 7.0;- .Net Framewor 4.0 Integrated;- Oracle Client 11;#######################Am I missing some driver?Thanks,Andrew Paes 5244Views Crystal Reports Windows Server 2008 ORA-12154: TNS:could not resolve the connect identifier specified Dell Stinnett-Christy Jan 10, 2013 9:27 PM (in response to Andrew Paes) Currently Being Moderated This is an Oracle error, not a Crystal error. On the machine where you're having the problem, try to TNSPing the database you're trying to connect to - this will identify whether the computer can "see" the database.-Dell Alert Moderator Like (0) Re: Crystal Reports Windows Server 2008 ORA-12154: TNS:could not resolve the connect identifier specified Andrew Paes Jan 11, 2013 12:27 AM (in response to Dell Stinnett-Christy) Currently Being Moderated Hi Dell,Thanks for your response.But my oracle client is installed and my other application can access my database oracle using tnsnames. But my reports can not.I did tnsping and everything happens right.Maybe my client oracle is wrong to SAP.My server is Win2008 64 bit. Do you know w
+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. ORA - 12154 error while using Crystal Reports for Enterprise Search this topic...|Search Crystal Reports...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts
Ora 12154 Tns Could Not Resolve Service Name
Register or Login to Post Forum Index -> Building Reports -> Crystal Reports Author Message ora 12154 tns no listener srithotakuraForum MemberJoined: 23 Mar 2012Posts: 3 Posted: Wed May 15, 2013 2:09 pmPost subject: ORA - 12154 error while using Crystal Reports for Enterprise ora 12154 tns could not resolve service name oracle 9i Hello, I am having hard time figuring what's wrong with Crystal Reports for Enterprise. I have created a unx universe using Information Design Tool and publiched it to the repository. When I try to create a report using Crystal http://scn.sap.com/thread/3291225 Reports for Enterprise, I am getting the following error Error: []
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of http://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign ora 12154 up Oracle ORA-12154: TNS: Could not resolve service name Error? up vote 11 down vote favorite 5 I am a SQL Server user . I am on a project that is using oracle (which I rarely use) I need to create an ODBC connection so I can access the some data via MS Access I have a application on my machine called oraHome90. ora 12154 tns It seems to allow a configuration of something called a listener in a “net configuration utility”, I think that a “Local Net Service Name Configuration” needs to also be done. The IT support gave me this information to set up the ODBC connection . I have tried every combination that I can think of. I can get past a test that successfully passes a test to “login“ to the oracle server database. When I try to create the ODBC connection I get the following error: ORA-12154: TNS: Could not resolve service name. Assuming that I want to start from scratch and the following information is supposed to allow for me to connect to the database….. Any suggestions or comment ? Note: ultimately the project will have a website .ASP page query the data, but I have to first prove that I can see the data using the ODBC connection via MS Access Service name: SERVICENAME HOST = HOST.XYZi.com User Id: MYUSERID Password: MYPASSWORD ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 'Oracle Connection Dim ocst Dim oconn ocst = "Provider=OraOLEDB.Oracle;" & _ "Data Source=DATASOURCE;" & _ "User ID=CHIJXL;" & _ "Password=password;" set oc