
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.