Registering data sources for ODBC

About this task

Before your Domino® Designer application can access data in a relational database, you must register a data source that tells the ODBC driver manager how to locate the data. Registering a data source ties a specific ODBC driver with the data to be accessed. The registration information includes the data you want to access, its associated server or directory, the back-end DBMS, and the network platform. To register this information in a registration file (ODBC.INI in Windows™ 95), you use the Windows Control Panel, a utility such as the Windows ODBC Administrator Utility, or a script or formula.

Note: For DataLens programs that use Windows 3.1, ensure that the data sources named in those programs are registered in ODBC.INI (not DATALENS.INI).

To register a data source for ODBC in Windows

About this task

You can use the operating system to register a data source for ODBC. Using the operating system allows you to register the data source hardware, software, and database type.

Use the following steps to register a data source in Windows 2000. Other operating systems may require slightly different steps.

Procedure

  1. From the Start menu, choose Settings - Control Panel - Administrative Tools - Data Sources (ODBC).
  2. Click Add.
  3. Select the driver you want, and click OK.
  4. Enter the data source name, description, and requested information.
  5. Some drivers require additional information; enter any other information necessary and click OK.
  6. Click Close.