Client TT Configuration Requirements: The TimesTen server as the server must be configured in SYS. ODBC. ini
For example, the existing TimesTen server is on 192.168.161.42, and The DSN is ocs_test.
How do I configure client connection on 192.168.161.43?
1. Configure the SYS. ODBC. ini file on the server, which is located in the $ tt_home/INFO/directory. For example, configure the system DSN = ocs_test
########################## Sys. ODBC. INI ####################################### ####
[ODBC data sources]
Ocs_test = TimesTen 6.0 driver
[Ocs_test]
Driver =/TimesTen/integration/TimesTen/integ/lib/libtten. So
Datastore =/TimesTen/integration/TimesTen/integ/integ_data/ocs_test
Smpoptlevel = 1
Durablecommits = 0
Memorylock = 0
Exclaccess = 0
Connections = 100.
Isolation = 1
Locklevel = 0
Permsize = 64
Tempsize = 32
Threadsafe = 1
Waitforconnect = 0
Authenticate = 0
Logging = 1
Oracleid = home128
Oraclepwd = ods30
Uid = ods30
######################################## ######################################
2. Configure Client Connection
1) obtain the TimesTen server port number and run the following command in the server's host shell:
$> Ttstatus | grep "TimesTen server"
Use the preceding command to obtain the following information: The TimesTen server port number is 12005.
TimesTen server PID 2961 started on port 12005
2) Open the SYS. ttconnect. ini file of the client, which is located in the $ tt_home/INFO/directory.
For the configuration of this file, refer to the demo and get a service name and configure the network_address and tcp_port parameters.
The configured file is as follows:
######################################## ##################
[Ocs3_tt604]
Description = TimesTen Server
Network_address = 192.168.161.42
Tcp_port = 12005
######################################## ##################
3. Configure the SYS. ODBC. ini file of the client, which is located in the $ tt_home/INFO/directory.
There are mainly the following options:
Ttc_server: The value is the service name configured in SYS. ttconnect. ini, for example, ocs3_tt604 in step 2.
Ttc_server_dsn: The value is the DSN of the server TimesTen server.
UID: the Default User name used to access the table by TT.
The configured file is as follows:
######################################## ##################
[ODBC data sources]
Mytest = TimesTen 7.0 client driver
[Mytest]
Ttc_server = ocs3_tt604
Ttc_server_dsn = ocs_test
Uid = ods30
######################################## #################
4. For the DSN connection method in CS mode, use the ttisqlcs command.
Run the following command on the client machine shell:
$> Ttisqlcs mytest
Configuration complete