Export sys.odbc.ini for Client/Server Connections outside Grid (gridClientExport)

The gridClientExport command produces a sys.odbc.ini file that can be used by TimesTen instances that are not part of the grid to access databases in the grid.

ttGridAdmin gridClientExport [filepath]

The resulting file contains definitions of all client/server connectables defined in the grid. You must manually copy this file to any TimesTen client instances outside of the grid from which you want to connect to databases in the grid.

Options

The gridClientExport command has the option:

Option	Description
filepath	Path and name of the file where the sys.odbc.ini entries are written. If no file is specified, the entries are output to stdout.

Examples

This example exports the sys.odbc.ini entries to the file sys_export.odbc.ini, then shows the contents of that file.

% ttGridAdmin gridClientExport /sw/tten/grid/clients/sys_export.odbc.ini
% cd /sw/tten/grid/clients
% more sys_export.odbc.ini
[ODBC Data Sources]
database1client=TimesTen 22.1 Client Driver
 
[database1client]
TTC_SERVER_DSN=database1
# External address/port info for mysys3host.instance1
TTC_SERVER1=mysys3.example.com/21000
# External address/port info for mysys4host.instance1
TTC_SERVER2=mysys4.example.com/21000
ConnectionCharacterSet=AL32UTF8
UID=ttclient

Notes

This command uses the external address of the host.