Using ODBC to access relational databases

You can use the ODBC (Open Database Connectivity) Version 2.0 standard to access relational databases such as DB2® or Oracle. Using formulas or scripts embedded in Domino® objects, you can integrate the data from many external databases into Domino® applications. For example, a customer call-tracking application accessed via the Notes® client or Web browser can access customer financial data from an ODBC-compliant relational database management system. ODBC is available on Windows, AIX®, HP-UX, OS/2, and the Mac PowerPC®.

Files required to use ODBC

When you install Domino® Designer, ODBC modules that support external data access install automatically.

In addition to these modules, you need an ODBC library (or shared object) and a driver for the type of database you want to access. You purchase and install the library and driver separately. For Windows 95, for example, you need these modules on your workstation:

  • The ODBC 2.0 interface, available from Microsoft.

    The interface defines the library of ODBC functions that perform the connection, query, and data-retrieval processes.

  • The Driver Manager, available from Microsoft and other vendors.

    The manager loads the necessary drivers used to access the data and acts as an interface between Domino® and the drivers.

  • The ODBC drivers, available from vendors or available for no charge to Notes® and Domino® users on the web site http://www.lotus.com.

    These handle communication between the Driver Manager and the databases. Domino® supports a variety of drivers. Each driver affects the specific capabilities of your application and comes with its own installation, configuration, and Help documentation.

    Note: Do not mix 32-bit and 16-bit versions of drivers, driver managers and Domino®. When using 32-bit Notes® clients or servers, use a 32-bit driver manager and 32-bit drivers. When using a 16-bit Notes® client or Domino® server, use a 16-bit driver manager and 16-bit drivers to use ODBC to make successful connections.

    Some Domino® applications include ODBC drivers that are licensed specifically for use with that application. Domino® cannot use these drivers. If you try to use these drivers, a message appears stating that you must have a license. You may be given a phone number or other information.

For more information about ODBC, see the Microsoft ODBC 2.0 Programmer's Reference and SDK Guide published by Microsoft Press.