Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle ODBC connection for Crystal Reports

Posted on 2009-07-13
13
Medium Priority
?
1,104 Views
Last Modified: 2013-12-19
I need to connect Crystal to an Oracle Database.  I have the DB in the tnsnames file.  I set-up the odbc connection and tested the connection and it is fine,  When I go to connect Crystal I keep getting the following error: ORA12154,  I also noticed that the tnsnames are not populating in the drop-down in the ODBC connection like my other computer.

Please help.
0
Comment
Question by:nobile00
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 

Author Comment

by:nobile00
ID: 24845198
The connection is also fine in SQL Developer
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24845257
Test without ODBC. See below, change ORA1 to the name of your service/database.

1) tnsping ORA1

2) sqlplus user/pass@ORA1



If these fail make sure your tnsnames.ora does not have a syntax error. sample below/

# Replace CAT with your database instance name
# Replace the ip address with your server's ip address
CAT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = CAT)
    )
  )

Open in new window

0
 

Author Comment

by:nobile00
ID: 24845312
Tried the above and crystal is still returning a ORA12154

Any reason the tnsnames are not populating in the ODBC connection drop-down.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:nobile00
ID: 24845315
The pings came back fine.
0
 

Author Comment

by:nobile00
ID: 24845353
this is the tnsnames entry:

STAGING =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = icolims-dev-db.lab.iconcr.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = ICOLIMS)
    )
  )
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24845445
Do you have multiple ORACLE HOMEs?
0
 

Author Comment

by:nobile00
ID: 24845487
where would I look to find if I have multiple homes?  As far as I know I only have one.
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24845510
If windows, try your registry:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

You also should make sure the user running .NET has privs. If the user that installed Oracle is a different user, that may cause the 2nd user not to see the Oracle libs and config.
0
 

Author Comment

by:nobile00
ID: 24845543
only one home listed.

Not sure what you mean about the .net
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24845564
Sorry I got the thread confused. I meant Crystal Reports / ODBC. There is another thread open with similar problem from .NET client.

Try setting ORACLE_HOME in the environment prior to starting Crystal reports.

set ORACLE_HOME=C:\oracle\10.2.0\...

Whatever your home is.


0
 

Author Comment

by:nobile00
ID: 24845590
Sorry but how do i do the above?  
0
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 2000 total points
ID: 24845619
I was talking about a DOS command prompt, but I don't know Crystal reports.

Check your System environment variables. See that the Oracle bin directory is in the PATH.

Are you using the same user for Crystal Reports as for ODBC
0
 

Author Closing Comment

by:nobile00
ID: 31603084
Thanks
Your info as well as a re-install of the client worked.
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question