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
`[DSN]`	The `DSN` is required. It is the name of the DSN, as specified in the ODBC Data Sources section of your `.odbc.ini` file.
`Driver=driver-path-name`	The TimesTen driver that is linked with the data source.
`DataStore=data-store-path-prefix`	The directory path and prefix of the database to access. This is required.
`DatabaseCharacterSet=Database-character-set`	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.
`CacheAdminWallet=1`	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 `CacheAdminWallet` connection attribute to 1 is recommended when using cache, but optional. See CacheAdminWallet in Oracle TimesTen In-Memory Database Reference
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
`[DSN]`	The `DSN` is required. It is the same DSN specified in the ODBC Data Sources section of the `.odbc.ini` file.
`TTC_Server=server-name`	The `server-name` is required. It is the DNS name, host name, IP address or logical server name for the TimesTen server.
`TTC_Server_DSN=server-DSN`	The `server-DSN` is required. It is the name of the data source to access on the TimesTen server.
`TTC_Timeout=value`	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