Installing and Setting Up Bolero

Setting Up the ODBC Data Source

In this stage, you will set up an ODBC connection (also called a data source) on the Bolero server. This data source tells Bolero how to connect to the Butler SQL server. If you already know how to set up an ODBC data source, do so (name the data source 'Bolero') and go to Stage 5. You should already have Butler SQL, Tango, and Bolero installed.

ODBC data sources are configured using the ODBC Setup control panel on the Bolero server.

To set up the ODBC data source:

Open the Control Panels folder in the Bolero server's System Folder.
    The Control Panels window is displayed. The ODBC Setup control panel is displayed here.

Note


    If you have a Macintosh with a PowerPC processor, you may have two ODBC Setup Control Panels: ODBC Setup and ODBC Setup PPC. Currently, Butler SQL data sources can be created with the ODBC Setup Control Panel only.

    Double-click on the ODBC Setup control panel icon.



    The ODBC Setup window is displayed.

Click Setup Data Sources...
    The ODBC Data Sources dialog box is displayed.



    This dialog box lists any existing data sources on this machine.
Click Add...
    The select ODBC driver dialog box is displayed.



    This dialog box lists the ODBC drivers installed on this Macintosh. ODBC uses a driver to communicate with each type of database.

    When you installed Bolero, the Butler SQL ODBC driver was also installed.
Select Butler SQL Driver and click OK.
    The ODBC data source configuration dialog box is displayed.

Enter the name 'Bolero' for this data source.
    Bolero uses this name to identify the data source it will use for the database connection.
Enter a description into the Description field (optional).
    Use this field to record the purpose or use of this data source.
Enter "BoleroDatabase" in the Database field.

Choose the Link Type from the Link Type pop-up menu.
    You can use Program Linking or TCP/IP to connect to a Butler SQL server. In order to connect to Butler SQL from Bolero, you must create a port on the machine acting as the Butler SQL server (it must be the same type as the selected link type).

    After you choose a link type, the other fields in the Link Type section change to allow configuration of the link type.
The steps that follow are for creating a Program Linking connection type. Click here to see the steps for configuring a TCP/IP link type.
    To configure a Program Linking link type, you need to identify the Butler SQL server's network zone, machine name, and port name.



    You can enter these manually, or you can select these from a network browsing dialog box.
Click Configure... to select the zone, machine name, and port name from the network browsing dialog box.


    If your network does not have any zones, the AppleTalk Zones list will not be displayed.
Select the network zone containing the Butler server to which you wish to connect.
    The Macintoshes list changes to display the Macintosh computers connected to the selected network zone.
In the Macintoshes list, select the Butler SQL server that contains the Bolero database.
    The Butler SQL Servers list changes to list the installed and enabled Butler SQL ports on the selected Macintosh.

Note


If you don't see the server's name in the list, the machine may not be running or program linking may not be turned on. Make sure the machine is on, that a Program Link port is installed, and that program linking is enabled (both in Butler SQL and the system software).

In the Butler SQL Servers list, select the name of the Butler SQL server's Program Link port.

Click OK.
    The selected zone, Macintosh, and port are entered into the Link Type fields in the ODBC configuration dialog box.

    If you are connected to a network with only one zone, an asterisk ("*") will be entered into the zone field.

The following steps detail the configuration of a TCP/IP link type.
    Enter the TCP/IP address of the server into the Host Name field. Press Tab.
Enter the port number assigned to the TCP/IP port in Butler SQL in the Port field.
    You may need to change the default port number.

    The port number must be the same as the port number assigned to the TCP/IP port on the Butler SQL server. Normally, you do not need to change the default port number.

    Click OK to save the data source.
If you are finished modifying data sources, click the Close button in the ODBC Setup Control Panel window. This data source is now available to Bolero.

Note


The values displayed in the Allow Asynchronous Operation settings are defaults which do not normally need to be changed. The default value is Full Asynchronous Mode.

You have now set up the ODBC data source on your Bolero server to communicate with the Butler SQL server.

Continue the installation with Stage 5-Minimal Configuration of the Bolero Settings File.

Click here to return to the main Installing and Setting Up page.

Home Page - Reports