Parks and Recreation Knowledge Base

How to install the ODBC connection for RecTrac

Updated on

An ODBC connection must be installed on any computer one wishes to use external reporting tools, such as Crystal Reports, with data from the RecTrac database. This article will walk you through installing the required Progress driver and adding the ODBC connection in Windows.

1. Get the Necessary Files

Note: At the time of this screenshot, Progress was on version 11.3 but this may change. Please make sure you're using the latest version of Progress when making an ODBC connection.

  1. Navigate to the Shared Folder > Management > Software > Progress 11.3 (RecTrac ODBC)
  2. Copy the 113_00 folder to your desktop.
  3. Create a folder named VSI3 at the root of the C: drive and copy the .PEM file to this new folder.
2. Install the Progress Driver
  1. Navigate to the 113_00 folder on your desktop.
  2. Right-click on Setup.exe.
  3. Select Run as Administrator.
  4. Click Yes if you get a User Account Control prompt.
  1. Click Next on the Welcome Screen.
  2. Enter the serial number 006013408.
  3. Enter control number Z8DRH.
  4. Enter control number TPM6D.
  5. Enter control number N4GYM.
  6. Click Accept.
  7. A product name will show under Products to be installed.
  8. Click Next.
  9. Complete the installation using all defaults.
3. Set up the ODBC Connection

NOTE: On 64bit operating systems there are two versions of the ODBC Data Source Admin program, one for 32bit applications and one for 64bit applications. Data sources are not shared between the two versions so if you will be using both 32bit and 64bit applications the connection will have to be setup twice. For reference, Crystal Reports is a 32bit application and the 32bit version of the ODBC program is located at C:\Windows\SysWOW64\odbcad32.exe.

  1. Go to the Control Panel > Administrative Tools > Data Sources (ODBC) OR open the program per the note above.
  2. Go to the System DSN tab.
  3. Click Add.
  1. Select Progress OpenEdge 11.3 Driver.
  2. Click Finish.
  1. The above screen will display. Fill out the General tab as follows:
  2. Data Source Name: RecTrac ODBC
  3. Description: RecTrac
  4. Host Name: apps2.vermontsystems.com
  5. Port Number: 11263
  6. Database Name: mdpgparks
  7. User ID: mdpgparksodbc@vsi
  1. Click on the Security tab and enter the following:
  2. Encryption Method: 1 - SSL
  3. Truststore: C:\VSI3\VSI-ODBC-E.pem
  4. Host Name in Certificate: FO-DB01-E
  5. Click Test Connect and enter the following password: aFpdiyZxzp
Previous Article How to refresh a roster
Next Article Site Acronym Cheat Sheet

General

Helpful Tips 7

Other Resources

Print Article