Connecting Using TimesTen ODBC Drivers

Your application can connect to the TimesTen database using TimesTen ODBC drivers.

TimesTen includes the following TimesTen ODBC drivers:

• TimesTen Data Manager driver: A TimesTen ODBC driver for use with direct connect applications.

• TimesTen client driver: A TimesTen client ODBC driver for use with client/server applications.

An application that links directly with a TimesTen ODBC driver (whether it is linked with the direct driver or client driver) is limited to using only the driver with which it is linked. An application linked directly to a TimesTen ODBC driver can connect to multiple databases at the same time. The TimesTen direct and client drivers support multiple connections to multiple TimesTen databases.

Note:

This option offers less flexibility but better performance than linking with a driver manager. However, an application should use a driver manager when connecting with both direct and client-server connections. If you are going to use a driver manager, use the TimesTen driver manager over a generic ODBC driver manager to maximize performance and functionality.

TimesTen includes the following two versions of the TimesTen Data Manager driver (direct driver):

• Production: Use the production version of the TimesTen Data Manager driver for most application development and for all deployment.

• Debug: Use the debug version of the TimesTen Data Manager driver only if you encounter problems with TimesTen itself. This version performs additional internal error checking and is slower than the production version. On Linux and UNIX, the TimesTen debug libraries are compiled with the -g option to display additional debug information.

For TimesTen support on Windows, you can install the "TimesTen Client 26.1" driver after choosing either the Typical or Custom setup.

On Linux and UNIX, depending on the options selected at install time, TimesTen may install the TimesTen client driver and both the production version and the debug version of the TimesTen Data Manager driver.

Table 1-1 lists the TimesTen ODBC drivers for Linux and UNIX platforms.

Table 1-1 ODBC Drivers Provided for Linux and UNIX Platforms

Platform	Version	Location and name
Linux Solaris x86 Solaris Sparc	Production	timesten_home/install/lib/libtten.so TimesTen Data Manager 26.1 driver.
Linux Solaris x86 Soliaris Sparc	Client	timesten_home/install/lib/libttclient.so TimesTen Client 26.1 driver.
AIX	Production	timesten_home/install/lib/libtten.a TimesTen Data Manager 26.1 driver.
AIX	Client	timesten_home/install/lib/libttclient.a TimesTen Client 26.1 driver.
macOS	Client	timesten_home/install/lib/libttclient.dylib TimesTen Client 26.1 driver.