odbc.ini File Entry Descriptions
The following sections describe the entries in the odbc.ini
file.
Note:
In TimesTen Scaleout, use the ttGridAdmin
gridClientExport
command to create a system or user
odbc.ini
file to be used by the TimesTen Client instance. See
Establishing Client Connections from a TimesTen Client in Oracle TimesTen In-Memory Database Scaleout User's
Guide.
ODBC Data Sources
Each entry in the optional ODBC Data Sources section lists a data source and a description of the driver it uses.
The data source section has the following format:
[ODBC Data Sources] DSN=driver-description
-
The
DSN
is required and it identifies the data source to which the driver connects. You choose this name. -
The
driver-description
is required. It describes the driver that connects to the data source.
The optional Data Sources section, when present in the system DSN file on the TimesTen Server, is used during the setup of Client DSNs. All system DSNs are made available to the Client DSN setup for the ODBC Data Source Administrator on the client, which displays all available DSNs on the TimesTen Server. The user can always add a new system DSN in the ODBC Data Source Administrator. When adding DSNs to the system DSN file, you should only include those DSNs that can be advertised to clients. All system DSNs are potentially accessible through the client/server configuration, even if they are not advertised.
DSN Specification
Each DSN listed in the ODBC Data Sources section has its own DSN specification.
The DSN specification for Data Manager DSN could have the format shown in Table 1-2.
Table 1-2 Data Source Specification Format
Component | Description |
---|---|
|
The |
|
The TimesTen driver that is linked with the data source. |
|
The directory path and prefix of the database to access. This is required. |
|
The database character set determines the character set in which data is stored. The database character set is required and cannot be altered after the database has been created. See Choosing a Database Character Set. |
|
Designates that when TimesTen registers the cache administration user credentials,
the credentials are saved in an internally managed Oracle Wallet
rather than in memory. Setting the |
Optional attributes |
See Connection Attributes in Oracle TimesTen In-Memory Database Reference. |
For example, the database1
DSN could have a specification that includes the following. Note that /disk1/timesten
is the timesten_home
.
[database1] Driver=/disk1/timesten/lib/libtten.so DataStore=/disk1/timesten/sample_db/DemoDataStore/database1 CacheAdminWallet=1
The database specification for TimesTen client DSN could have the format shown in Table 1-3.
Note:
While the syntax for the TimesTen client DSN is listed here, full directions for setting the client DSN and server DSN are located in Defining Server DSNs for TimesTen Server on a Linux or UNIX System and Defining Client DSNs on a TimesTen Client System.
Table 1-3 Database Specification for TimesTen Client Configurations
Component | Description |
---|---|
|
The |
|
The |
|
The |
|
Client connection timeout value in seconds. |
Note:
Most TimesTen driver attributes are ignored for TimesTen client DSNs.
For example, the client/server data source database1CS
that
connects to database1
on the TimesTen server ttserver
could have a data source specification that includes the following:
[database1CS] TTC_Server=ttserver TTC_SERVER_DSN=database1 TTC_Timeout=30
odbc.ini File Example
The following example shows portions of a Linux or UNIX
.odbc.ini
file. Note that /disk1/timesten
is the timesten_home
.
... [ODBC Data Sources] database1=TimesTen 22.1 Driver ... [database1] Driver=/disk1/timesten/lib/libtten.so DataStore=/disk1/timesten/sample_db/DemoDataStore/database1 PermSize=128 TempSize=64 DatabaseCharacterSet=AL32UTF8 CacheAdminWallet=1 ... ######################################################################## # This following sample definitions should be in the .odbc.ini file # that is used for the TimesTen 22.1 Client. # The Server Name is set in the TTC_SERVER attribute. # The Server DSN is set in the TTC_SERVER_DSN attribute. ######################################################################### [ODBC Data Sources] database1CS=TimesTen 22.1 Client Driver ... [database1CS] TTC_SERVER=localhost TTC_SERVER_DSN=database1 ...