Home » SQL & PL/SQL » Client Tools » Oracle + Crystal Reports on Windows 7 64 Bit Machine
Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #492667] Tue, 01 February 2011 12:50 Go to next message
fmrock
Messages: 45
Registered: December 2006
Member
Hello everyone,

I recently got a new PC at work which is Windows 7 64 bit.

We run lots of crystal reports(1000's) that pull data from an oracle back end.

I have installed the Oracle Client 32 bit on this machine and have no problem connecting to the database and pulling back data.

However, when I use crystal to access the TNS Name it gives me the following error.

http://ora-12154.ora-code.com/

My path variable on the PC has

"C:\oracle\product\10.2.0\client_1\BIN;".

I also tried to create and ODBC using the 32bit ODBC on the machine and that connects fine, but when you try to access the DSN from Crystal, I still get the 12154 error.

Does anyone have any suggestions on how to fix this or anything else I could try?



Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #492670 is a reply to message #492667] Tue, 01 February 2011 13:00 Go to previous messageGo to next message
BlackSwan
Messages: 22897
Registered: January 2009
Senior Member
ORA-12154 means the TNS_ALIAS used in the connection string could NOT be resolved.
Problem is local to client machine.
A frequent cause is missing/wrong entry in tnsnames.ora file.
If sqlnet.ora file exists on client system, please its content.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #492672 is a reply to message #492670] Tue, 01 February 2011 13:11 Go to previous messageGo to next message
fmrock
Messages: 45
Registered: December 2006
Member
SQL+ can connect and return data. The tnsnames.ora is the same as the file on my windowsXP machine.

sqlnet.ora
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)


tnsnames.ora
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

DBCMIS3 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.111.111)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBAH1)
    )
  )

DMIS3 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 22.22.22.222)(PORT = 1526))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DMIS5)
    )
  )





Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #492673 is a reply to message #492672] Tue, 01 February 2011 13:15 Go to previous messageGo to next message
BlackSwan
Messages: 22897
Registered: January 2009
Senior Member
>SQL+ can connect and return data. The tnsnames.ora is the same as the file on my windowsXP machine.
Then I can only conclude that Crystal Reports is NOT using the same tnsnames.ora that works for sqlplus;
or it is using different tns_alias.
Problem cause & fix is external to Oracle.
Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #492674 is a reply to message #492673] Tue, 01 February 2011 13:21 Go to previous messageGo to next message
fmrock
Messages: 45
Registered: December 2006
Member
I also used the process monitor to monitor what Crystal was doing and here is a screen shot of the results.

I agree this is a crystal issue, just look for any ideas on what to do to fix this problem.

Also, the only .ora files on this computer are in the C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN and C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\SAMPLE folders.

[Updated on: Tue, 01 February 2011 13:23]

Report message to a moderator

Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #492689 is a reply to message #492674] Tue, 01 February 2011 15:40 Go to previous messageGo to next message
Littlefoot
Messages: 19677
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try to create TNS_ADMIN environment variable; point it to a directory that contains TNSNAMES.ORA file that lists databases you use. That would be
set tns_admin=C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
(from command prompt; you do that through Control Panel - System). Then start Crystal reports and try again.

I'm fairly new to Windows 7; from what I can tell, it behaves somewhat differently from XP. One difference is that - when setting the environment variable - it remains unknown until Windows is restarted. Though, it might be me not knowing how to use it properly. Just make sure TNS_NAMES is properly set.

If it doesn't help, what is a complete path to Crystal reports? Does its directory contain brackets? Such as "c:\program files (x86)\crystal reports"? If so, try to install it into another directory (I'd suggest "c:\crystal"). TOAD, for example, won't work if installed into a directory that contains brackets, and will return ORA-12154 until reinstalled.

From what I can tell, don't try to "fool" it by forcing installation into "c:\program files" (which is supposed to contain 64-bit applications, while (x86) contains 32-bit ones) because installer - somehow - (AI?) creates some files in (x86) and it is a complete mess. So - just install it into "c:\crystal".

No more ideas.
Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #492695 is a reply to message #492689] Tue, 01 February 2011 16:30 Go to previous messageGo to next message
ThomasG
Messages: 3100
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Littlefoot wrote on Tue, 01 February 2011 22:40
try to install it into another directory (I'd suggest "c:\crystal").


Ahhhh, that nudged a memory we had a somewhat similar unexplainable connection problem on 64 bit Windows. SQLPlus and all oracle tools worked, SQL Server couldn't connect to Oracle with an ORA-12154 related error.

What is your EXACT client version, fmrock? There is a bug in 10.2.0.1 regarding 64 bit connections that is solved in patch set 10.2.0.4. (The server also needs to be at least 10.2.0.4.)


Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #492785 is a reply to message #492667] Wed, 02 February 2011 09:03 Go to previous messageGo to next message
fmrock
Messages: 45
Registered: December 2006
Member
I uninstalled crystal and resinstalled it in C:\Crystal and it now works. I did this with both versions9 and 2008. Both work now.

Thanks for your help
Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #600832 is a reply to message #492689] Tue, 12 November 2013 21:07 Go to previous message
aroraak
Messages: 1
Registered: November 2013
Location: Brisbane
Junior Member
The addition of the system variable worked for me. 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 OFF
Goto Forum:
  


Current Time: Mon Oct 20 05:08:35 CDT 2014

Total time taken to generate the page: 0.16526 seconds