Installing Crystal Reports 2008 and MySQL Connector/ODBC 3.51

Install Crystal Reports 2008 Release 2 on a different computer from the Vocera Report Server. To connect from Crystal Reports to your Vocera Report Server, you need to install the MySQL Connector/ODBC 3.51 driver and set up an ODBC data source.

Important:

DO NOT install Crystal Reports Server on the same machine as Vocera Report Server. Vocera Report Server has not been certified to work on computers where Crystal Reports Server is also installed.

To install Crystal Reports 2008 Release 2 and MySQL Connector/ODBC 3.51:

  1. Download the MySQL Connector/ODBC 3.51 driver from the following location:

    http://dev.mysql.com/downloads/connector/odbc/3.51.html

    Note:

    Vocera Report Server requires MySQL Connector/ODBC 3.51.27 or later.

  2. Install the MySQL Connector/ODBC 3.51 driver.

  3. Set up an ODBC data source to connect to your Vocera Report Server:

    1. Open the ODBC Data Source Administrator, which is usually found under Start > Programs > Administrative Tools > Data Sources (ODBC), or Start > Settings > Control Panel > Data Sources (ODBC). The ODBC Data Source Administrator dialog box opens.

    2. Click the System DSN tab.

    3. Click Add. The Create New Data Source dialog box opens.

    4. Select the MySQL 0DBC 3.51 driver from the list.

    5. Click Finish.

    6. The Connector/ODBC 3.51.x dialog box opens with the Login tab selected. Enter the following information:

      Field

      Value

      Data Source Name

      VoceraReports

      Description

      Vocera Report Server connection

      Server

      [IP address of the Vocera Report Server machine]

      User

      vocera

      Password

      vocera

      Database

      vocera_reports

      Note:

      The User and Password values above are the default values for Vocera Report Server. If you changed the User and Password on the Vocera Report Server, use those values instead.

      The Connector/ODBC 3.51.x dialog box should look like this:

      Figure 1. Connector/ODBC 3.51.x dialog box

    7. Click OK to save the connection and close the Connector/ODBC 3.51.x dialog box.

    8. In the ODBC Data Source Administrator dialog box, click OK.

  4. Install Crystal Reports 2008 Release 2. For detailed instructions, see the separate Crystal Reports documentation.

  5. When prompted, restart the computer.

  6. After the computer restarts, run Crystal Reports.

  7. Log on to the VoceraReports data source:

    1. Choose File > Log On or Off Server. The Data Explorer dialog box opens.

    2. Expand the Create New Connection folder, and then expand the ODBC (RDO) folder. The ODBC (RDO) dialog box opens.

    3. Make sure the Select Data Source radio button is selected. In the Data Source Name list, select VoceraReports. Click Next.

      Figure 2. ODBC (RDO) dialog box

    4. Enter the UserID and Password. By default, both values are "vocera". If you changed the UserID and Password on the Vocera Report Server, use those values instead.

    5. Click Finish.