Skip to main content
Solved

Connect Oracle Client 12 to Crystal Reports 2016

N
Do Gooder (Customer)
Forum|alt.badge.img+4

I’m attempting to set up Crystal Reports 2016 so I can connect to the IFS Oracle database (Apps 9). I’m using Oracle Client 12. 

Firstly, I have not seen anyplace where it is specified the normal tnsnames.org file location for Oracle Client 12. Everything says “ORACLE_HOME” (which I understand means whatever the home  directory is not a directory literally named “ORACLE_HOME”) /network/admin. There is no network OR admin folder in the Oracle directory. To use SQL Developer, I don’t need that anyway, because I can just directly load a tnsnames.ora file.

 

But then Crystal reports… I have googled seven ways from Sunday and cannot figure out how the heck to associate the TNS file with Crystal Reports. When I go to “Database Expert”, I have an option for “Oracle Server”, but no matter what values I use (and I know they’re the correct values b/c I can connect with them in SQL Developer), I can’t connect. 

 

 

No one here is very savvy at this so there is no one I can ask.

 

Help!

 

Thank you!

 

Best answer by alanbclark

A couple hints.

  1. You must use an Oracle client that matches the architecture of your Crystal Report application. For example, if you installed the 32-bit Crystal Reports Developer then you must install an Oracle 32-bit client.
  2. What type of Oracle client did you install? (Instant, Runtime, Administrator, custom, etc.)?
  3. If you installed the instant client the folders may not have been created. Please re-install the Oracle client and either install the Runtime of Administrator option. This will create the proper folders and includes tools to create/edit the TNSNAMES.ORA file.

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

5 replies

alanbclark
Sidekick (Partner)
Forum|alt.badge.img+7
  • alanbclark
  • Sidekick (Partner)
  • 60 replies
  • Answer
  • March 23, 2021

A couple hints.

  1. You must use an Oracle client that matches the architecture of your Crystal Report application. For example, if you installed the 32-bit Crystal Reports Developer then you must install an Oracle 32-bit client.
  2. What type of Oracle client did you install? (Instant, Runtime, Administrator, custom, etc.)?
  3. If you installed the instant client the folders may not have been created. Please re-install the Oracle client and either install the Runtime of Administrator option. This will create the proper folders and includes tools to create/edit the TNSNAMES.ORA file.

 

-Alan
Kasun Balasooriya
Charith Epitawatta
pwlm
5 people like this
  • Kasun Balasooriya
    Kasun Balasooriya
  • Charith Epitawatta
    Charith Epitawatta
  • pwlm
    pwlm
  • ChanakaAmarasekara
    ChanakaAmarasekara
  • Srikanth
    Srikanth
william.klotz
Superhero (Customer)
Forum|alt.badge.img+21
  • william.klotz
  • Superhero (Customer)
  • 479 replies
  • March 23, 2021

Hi @NerakYak ,

 

The tnsnames.org file in my environment is located here.

C:\app\product\12.2.0\client_1\network\admin

 

Have you installed the Oracle Client on your machine?

You’ll have to install either the x32 or x64 bit Oracle Client on your local machine first then place the tnsnames.org file in the location such as C:\app\product\12.2.0\client_1\network\admin

 

Regards,

William Klotz

EntNadeeL
Hero (Partner)
Forum|alt.badge.img+10
  • EntNadeeL
  • Hero (Partner)
  • 181 replies
  • March 24, 2021

Hi @NerakYak ,

When you install oracle you need to install it in Administrator option and should install oracle client 32 bit in order to work with Crystal Reports. 

If you are getting the oracle server option that means you have the client version but it seems like you havent installed oracle in Administrator mode. Then only you will get app\product\12.2.0\client_1\network\admin folder where you can add database entry in tns file.

Hope this helps.

Kind Regards,

Nadeesha Liyanage - https://www.linkedin.com/in/nadeeshaliyanage/
EntShehaM
1 person likes this
  • EntShehaM
    EntShehaM
N
Do Gooder (Customer)
Forum|alt.badge.img+4
  • NerakYak
  • Author
  • Do Gooder (Customer)
  • 5 replies
  • March 24, 2021

Thanks, all! Now I need to wait for IT to re-install. Alas, I don’t have admin rights on my machine. :(

N
Do Gooder (Customer)
Forum|alt.badge.img+4
  • NerakYak
  • Author
  • Do Gooder (Customer)
  • 5 replies
  • March 26, 2021

It worked! Thank you so much! :)

 

Happy Friday!

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings