ttInstallDSN

The ttInstallDSN utility is a Windows-only utility. It generates a Windows client DSN for each of one or more entries in the provided input file and installs them into the ODBC control panel as system DSNs. For more information, see Create a User or System odbc.ini File in Oracle TimesTen In-Memory Database Operations Guide.

If you are using TimesTen Scaleout, use the ttGridAdmin gridClientExport command to generate the input file. For more information, see Adding a Client DSN to a TimesTen Client on Windows in Oracle TimesTen In-Memory Database Scaleout User's Guide.

Required Privilege

This utility requires the instance administrator privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This utility is supported in both TimesTen Classic and TimesTen Scaleout.

Syntax

ttInstallDSN [-h | -help | -?]

ttInstallDSN [-f file] [Client_DSN_Name | -a | -l] [-force]

Options

ttInstallDSN has the options:

Option Description

Option	Description
`-h` `-help` `-?`	Displays help information.
`-f` `file` `[Client_DSN_Name` `\| -a \| -l]`	Specifies the full path and name of a file (generated by `ttGridAdmin gridClientExport`) containing one or more DSN definitions. Also typically provide one of the following: The name of the DSN you want to install from the input file. The `-a` option to install all DSNs from the input file. The `-l` option to simply list all the DSNs in the input file. None is installed. If you do not specify `-f`, the default file is `sys.odbc.ini` in the current directory. If you do not specify one of the three items listed above, the default behavior is to list the DSNs in the file and ask which you want to install.
`-force`	If there are already DSNs in the Windows registry, this allows them to be overridden by the specified DSNs. Without this option, if there are already DSNs in the Windows registry, the utility issues a warning and cannot install new ones.

-h

-help

-?

Displays help information.

-f file [Client_DSN_Name | -a | -l]

Specifies the full path and name of a file (generated by ttGridAdmin gridClientExport) containing one or more DSN definitions. Also typically provide one of the following:

The name of the DSN you want to install from the input file.
The -a option to install all DSNs from the input file.
The -l option to simply list all the DSNs in the input file. None is installed.

If you do not specify -f, the default file is sys.odbc.ini in the current directory.

If you do not specify one of the three items listed above, the default behavior is to list the DSNs in the file and ask which you want to install.

-force

If there are already DSNs in the Windows registry, this allows them to be overridden by the specified DSNs.

Without this option, if there are already DSNs in the Windows registry, the utility issues a warning and cannot install new ones.

Examples

In this example, there are already DSNs in the Windows registry. The user first tries without -force and is issued a warning, so then uses -force.

C:\mydir> ttinstalldsn.bat -f c:\temp\sys.odbc.ini
--------------------------------
.ini File: c:\temp\sys.odbc.ini
--------------------------------
Found the following DSNs in available 'c:\temp\sys.odbc.ini'.
0 : database1CS
[ Please select the DSN to be imported: ]
0
Warning: The following DSNs already existed and were not added:
        database1CS

C:\mydir> ttinstalldsn.bat -f c:\temp\sys.odbc.ini -force
--------------------------------
.ini File: c:\temp\sys.odbc.ini
--------------------------------
Found the following DSNs in available 'c:\temp\sys.odbc.ini'.
0 : database1CS
[ Please select the DSN to be imported: ]
0
Modifying DSN 'database1CS'.