2 Working With TimesTen Databases in ODBC

This chapter covers TimesTen programming features and describes how to use ODBC to connect to and use the TimesTen database.

It includes the following topics:

• Management of TimesTen Database Connections

• Database Operations in ODBC

• TimesTen Features and Operations in Your Application

• Error Handling

• ODBC Support for Automatic Client Failover

• Client Routing API for TimesTen Scaleout

Note:

• For using OCI to access TimesTen from a C application, see TimesTen Support for OCI.

• For using Pro*C/C++ to access TimesTen from a C application, see TimesTen Support for Pro*C/C++.

• For accessing TimesTen from a C++ application, see Understanding and Using TTClasses in the Oracle TimesTen In-Memory Database TTClasses Guide.

• For accessing TimesTen from a C# application, see Getting started with ODP.NET in the Oracle Data Provider for .NET Oracle TimesTen In-Memory Database Support User's Guide.

TimesTen supports:

• ODBC 2.5, Extension Level 1, as well as Extension Level 2 features that are documented in TimesTen ODBC Support

• ODBC 3.51 core interface conformance