I have a 32-bit box running Windows 7 Enterprise SP1. (RAM is maxed.)
I am trying to connect Crystal Reports 2008 to an Oracle server, and I consistently get a message back from CR of "Unknown Database Connect Error".
I seem to have three copies of my tnsnames.ora file on my PC, in the following three locations:
I've ensured that all three of these tnsnames.ora files are identical.
I can connect to my desired database (engdev2) using SQL Developer, so I'm confident that the TNS entry is valid:
(ADDRESS = (PROTOCOL = TCP)(HOST = 126.96.36.199)(PORT = 1523))
(SERVER = DEDICATED)
(SERVICE_NAME = engdev2)
I've confirmed that in each of those directories, SQLNET.AUTHENTICATION_SERV
ICES = (NTS) in the sqlnet.ora files.
I'm running Crystal Reports 2008 in Windows XP SP3 compatibility mode. When I try to connect to this database, using an Oracle Server connection, I enter engdev2 as the service, I enter the user ID, I enter the password, and when I click Finish I immediately
get the above message back. (On the first effort after a reboot, there is a delay of about two seconds as it attempts this connection. Subsequently, there is no noticeable delay suggesting that the system is trying to connect to the database, even if CR has been quit and restarted.)
TNSPING from the command line gives me this result:
TNS Ping Utility for 32-bit Windows: Version 188.8.131.52.0 - Production on 04-JAN-2
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Message 3513 not found; product=NETWORK; facility=TNS
TNS-12557: TNS:protocol adapter not loadable
The local DBA says, "It's Crystal's fault. Uninstall, reboot and reinstall." That didn't make any difference at all – not that I expected it to.
Thanks for any direction you can provide on this.