On some systems that are accessing Oracle via the TNSNAMES.ORA configuration files (used by Campaign CSi software v4) and via the EZCONNECT method (used by Campaign Report Tool), users may need to set configuration in SQLNET.ORA as follows:
NAMES.DIRETORY_PATH = (TNSNAMES, EZCONNECT)
If this setting is not made, the Campaign Report Tool may give the following error:
ORA-12154: Could not resolve the connect identifier
This is unexpected because the EZCONNECT method is documented by Oracle as requiring no registry entries or configuration files. Indeed, the Campaign Report Tool is able to connect successfully on machines that do not have the Campaign CSi software installed. It appears the addition of the older Oracle drivers to a machine causes the SQLNET.ORA file to be read even when using EZCONNECT. In this case, the NAMES.DIRETORY_PATH must contain the EZCONNECT entry or the connection fails.