Using a Connection String in TimesTen

You can connect to a TimesTen database without a predefined DSN with any ODBC application or the ttIsql utility if the connection string contains the DataStore, Driver and DatabaseCharacterSet attributes. Define the connection string as follows:

  • The name or path name of the ODBC driver using the Driver attribute.

    • On Windows, the value of the Driver attribute should be the name of the TimesTen Client Driver.

    • On UNIX systems, the value of the Driver attribute should be the pathname of the TimesTen ODBC Driver shared library file (as described in Table 1-1). The file resides in the timesten_home/lib directory.

  • The database path and file name prefix using the DataStore attribute.

  • The character set for the database using the DatabaseCharacterSet attribute.

The following example shows how you can connect providing the Driver, DataStore and DatabaseCharacterSet attributes using a connection string in the ttIsql utility:

Providing the connection attributes on the connect string from a Linux/UNIX client. Note that /disk1/timesten is the timesten_home. 

% ttIsql 

Command> connect "Driver=/disk1/timesten/lib/libtten.so;
DataStore=/disk1/databases/database1;DatabaseCharacterSet=AL32UTF8";

Providing the connection attributes on the connect string from a Windows client:

C:\ ttIsql
Copyright (c) 1996, 2016, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
 
Command> connect "Driver=TimesTen Client 26.1;
DataStore=/disk1/databases/database1;DatabaseCharacterSet=AL32UTF8";