Home » Other » 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 Go to next message](/forum/theme/orafaq/images/down.png) |
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 #492672 is a reply to message #492670] |
Tue, 01 February 2011 13:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #492674 is a reply to message #492673] |
Tue, 01 February 2011 13:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 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 beset 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Littlefoot wrote on Tue, 01 February 2011 22:40try 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.)
|
|
|
|
|
Goto Forum:
Current Time: Tue Feb 18 22:48:01 CST 2025
|