Configuring Data Sources

From InterBase
Jump to: navigation, search

Below are the steps for configuring a data source:

  1. Select Start | Settings | Control Panel and double-click the ODBC entry. (If you have the ODBC SDK installed, you can run the “32bit ODBC Administrator” utility instead). The “ODBC Data Source Administrator” window opens.
  2. On the User DSN tab, click Add. The “Create New Data Source” window opens.
  3. Select the InterBase ODBC driver and click Finish. The “InterBase ODBC Configuration” window opens.
  4. Enter the following information:
    Data Source Name Make up a name for your data source

    Description

    A description of the data course (not required)

    Network Protocol

    Choose the protocol from the drop-down list

    Database

    Full physical path to the database, including the database name

    Server

    Server name; if you choose the protocol “local,” this will default to the local server

    Username

    Your database user name, or SYSDBA

    Password

    The database password corresponding to the Username

  5. Optionally, click Advanced and fill in CharacterSet and Roles information.
  6. Click OK to return to the “ODBC Data Source Administrator” window. You should see the data source you just added, listed under User Data Sources.