Home  /  Application Development: Language Bindings and Gateways  /  Using ODBC with InterSystems Products  /  Overview

Using ODBC with InterSystems Products
[Back]  [Next] 
InterSystems: The power behind what matters   

InterSystems ODBC provides ODBC drivers to enable you to access InterSystems IRIS™ via an ODBC connection. To use ODBC with InterSystems IRIS, install and configure the InterSystems ODBC client driver, then define one or more DSNs (Data Source Names) to refer to InterSystems IRIS databases. Your application can use the InterSystems IRIS DSN in the same way it would use any other DSN.
To use InterSystems IRIS as an ODBC data source, you must do the following:
See Using InterSystems IRIS as an ODBC Data Source on Windows or Using InterSystems IRIS as an ODBC Data Source on UNIX® for OS-specific instructions on how to perform these tasks.
ODBC Driver Support
The InterSystems ODBC drivers are compliant with ODBC 3.5.
InterSystems ODBC supports the following ODBC driver managers:
For more complete information, including specific supported databases, see the online InterSystems Supported Platforms document for this release.
An Overview of ODBC
An ODBC system has the following parts:
For a particular vendor database, that vendor may offer its own version of the ODBC client driver for that platform. Oracle, for example, supplies its own ODBC driver for use with Oracle databases on Windows. This may be preferred in some cases because the vendor driver may take advantage of its knowledge of how the database works internally to optimize performance or enhance reliability.
ODBC Connection Details
For an application to connect to a database via ODBC, the application must generally provide the following connection details:
In most cases, this information is stored within a DSN, which has a logical name for use within the client application. The DSN may or may not include login credentials, which can also be stored in the database initialization file, or not stored at all.
The DSNs must be registered with the ODBC driver manager.
In practice, a connection is established as follows:
  1. A client application includes ODBC calls that attempt to connect to a particular DSN. A client application is linked to an ODBC driver manager, which accepts the calls.
  2. The ODBC driver manager reads the initialization file to obtain the location of the ODBC client driver and load the client driver into memory.
  3. Once loaded into memory, the ODBC client driver uses the ODBC initialization file to locate connection information for the DSN, as well as other information. Using this information, the client driver connects to the specified database.
  4. Having established the connection, the client driver maintains communications with the database server.