SecurityExpressions: getting a connection error to Oracle Database

Article:TECH13414  |  Created: 2006-04-06  |  Updated: 2006-04-06  |  Article URL http://www.symantec.com/docs/TECH13414
Article Type
Technical Solution


Issue



I'm using the Microsoft ODBC for Oracle driver but when I try to create the tables I get an error that the Data Source name cannot be found.

Solution



There are four settings that need to be correct in order for SecurityExpressions to use an Oracle Database.  First the file TNSNAMES.ORA must have the correct information.  Below is an example simple TNSNAMES.ORA

# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

PMP.CSTEST.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = pmultiprocessor.pedestal.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = pmp.pedestal)
    )
  )

The second file is SQLNET.ORA.  Below is an example simple SQLNET.ORA:

# SQLNET.ORA Network Configuration File: E:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = cstest.com

SQLNET.AUTHENTICATION_SERVICES= (None)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

The third setting is the Server name.   The Server name in the Microsoft ODBC for Oracle setup screen must be the same as in TNSNAMES.ORA, in this example PMP.CSTEST.COM.

The fourth setting is the SQLNET.AUTHENTICATION_SERVICES, it must be (None).


Legacy ID



21591


Article URL http://www.symantec.com/docs/TECH13414


Terms of use for this information are found in Legal Notices