Resolution Path for a DSN

TimesTen uses certain rules when resolving a DSN.

Note:

• If a user DSN and a system DSN with the same name exist, TimesTen retrieves the user DSN.

• On Linux and UNIX, if there are multiple DSNs with the same name in the same odbc.ini file, TimesTen retrieves the first one specified in the file.

1. Searches for a user DSN with the specified name in the following files:

   1. The file referenced by the ODBCINI environment variable, if it is set.

   2. The .odbc.ini file in the user's home directory, if the ODBCINI environment variable is not set.

2. If no matching user DSN is found, TimesTen looks for a system DSN with the specified name.

   1. The file referenced by the SYSODBCINI environment variable, if it is set.

   2. The sys.odbc.ini file in the daemon home directory, if the SYSODBCINI environment variable is not set.

   3. On Linux and UNIX, the file is located in timesten_home/conf/sys.odbc.ini.