Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4890
  • Last Modified:

[Oracle][ODBC][Ora]Error while trying to retrieve text for error ORA-12154

I am trying to connect to an Oracle database and keep getting this error:  [Oracle][ODBC][Ora]Error while trying to retrieve text for error ORA-12154.  Can anyone help?
0
dick3677
Asked:
dick3677
3 Solutions
 
AnnetteHarperCommented:
ORA-12154 TNS is "Could not resolve service name" and indicates that the Oracle client is not properly installed or configured. Have you verified that you can access your Oracle database from SQL*Plus? Probably the service name does not exist in your TNSNames.ORA file.
0
 
dick3677Author Commented:
tnsnames.ora is OK.  SQLPlus is OK.
0
 
mlmccCommented:
What version of CR?  What version of Oracle?

I read somewhere that there are some incompatibilities between Oracle and CR which are version dependent.

mlmcc
0
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

 
AnnetteHarperCommented:
Hhmm, seems unlikely that you would get this particular error if you can connect OK using SQL*Plus. You don't by any chance have multiple Oracle Homes, do you? In that case, you may have multiple tnsnames files.

Also, can you verify that the DSN is OK using some other tool? Maybe Microsoft Query or Access or something? This is a lower level error than the ODBC layer, but this check might tell you something.
0
 
dick3677Author Commented:
I tried MS Query and got the same error.
0
 
AnnetteHarperCommented:
Well, at least you know its not Crystal then!

This situation seems a little odd to me. The error is saying that it can't resolve the service name, which means that it can't find a tnsnames file, or the name you've listed is not in the tnsnames file. (unless you use Oracle names instead of a tnsnames file)

Which ODBC driver are you using? The CR Oracle ODBC or Oracle's or some other one? Each one calls the service name something different, but verify that the name you're typing into the ODBC DSN setup matches the tnsname.

If you will post your tnsnames entry and tell me which ODBC driver you're using, I can verify the proper configuration for you.
0
 
PWinterCommented:
Hi.

Do you have any subreports? If yes, you have to verify each of them same way as you did for the main report.

Good Luck.
PW
0
 
JimGoebenCommented:
Did you find an answer to this? I had the same issue; however, I was able to see the query results, but other's were not. I added everyone with view rights to the security of the C:\oracle\ora92\ directory and that fixed it.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now