Automated Police Systems,
Inc.Automated Police Systems,
Inc.
The instructions below will allow you to setup and install the report writing and dispatch program on your computer. This program will only work on the computer where the program is installed. You will not be able to have multiple workstations accessing the same MySQL Server using the free version of the report writing and dispatch program available on this website. The network version of the report writing and dispatch program is available if we support your department's use of the report writing and dispatch program.
Download the self-extracting WinZip file named Setup Files.exe listed below. When you finish downloading the file, run it and select the "Unzip" command button to extract the setup files to the "C:\Temp" directory on your computer's hard drive. Change into the "C:\Temp" directory on your computer's hard drive and run the "Setup.exe" file to install the report writing program version 1.0.0.124.
After successfully installing the report writing program, you will need to download and install MySQL Server 4.0 on your computer. When you run this self-extracting WinZip file, choose the "Unzip" command button to extract the installation files for the MySQL Server to the "C:\Temp\mysql" folder on your hard drive. After extracting the setup files for the MySQL Server to your hard drive, change into the "C:\Temp\mysql" folder and run the "Setup.exe" file to install the MySQL Server in the default installation directory "C:\mysql" folder. After you install the MySQL Server, start the server by changing into the "C:\mysql\bin" directory and run the file named "winmysqladmin.exe".
MySQL Server will hold all of the data entered into the report writing program. All data is saved on the computer where the MySQL Server and report writing program is installed.
After you successfully install MySQL Server on a computer on your network, download the MySQL Report Data Files.exe listed below. When you finish downloading the file, run it. You will need to extract the data files into the "mysql\data" directory on the computer running the MySQL Server. Select the "Unzip" command button to extract the data files used by the report writing program to your computer's hard drive.
After successfully installing the MySQL Server on your network, you will need to install the MySQL Connector/ODBC 3.5 and install it on all computers that will run the report writing program.
You will need to configure an ODBC Connection on each workstation so the report writing program can access and save data to the MySQL Server on your network. Use the below information to setup a new DNS on your computer. You will need to access the control panel in Windows. Depending upon the Operating System you are using (I will assume you are using Windows XP), go to the “Start” button and select “Settings”. Select “Control Panel” from the menu. This will open a window and you need to select the “Administrative Tools” icon. This will open a window containing the Administrative Tools for your machine. You may have to have administrator access to get to this window. If so, contact your network administrator and have them setup the ODBC Connection by following these instructions.
You will need to open the “Data Source (ODBC)” shortcut and “Add” a new ODBC Data Source. When the “ODBC Data Source Administrator” box opens, select the “Add” command button and a window will open named “Create New Data Source.” Scroll down the list until you see “MySQL ODBC 3.51 Driver” and highlight (select) this option. Your screen should look something like this.
After you select the "MySQL ODBC 3.5 Driver", select the “Finish” command button and a new window will appear named “MySQL ODBC 3.51 Driver – DSN Configuration, Version 3.51.09". You need to put the following values in the boxes available for you.
Select “Test Data Source” to see if the connection is working. If not, check the above values. They have to appear as you see listed above. When you establish a connection, select “OK” and close the dialog box.
You will need to open the “Data Source (ODBC)” shortcut and “Add” another new ODBC Data Source. When the “ODBC Data Source Administrator” box opens, select the “Add” command button and a window will open named “Create New Data Source.” Scroll down the list until you see “MySQL ODBC 3.51 Driver” and highlight (select) this option. Your screen should look something like this.
After you select the "MySQL ODBC 3.5 Driver", select the “Finish” command button and a new window will appear named “MySQL ODBC 3.51 Driver – DSN Configuration, Version 3.51.09". You need to put the following values in the boxes available for you.
Select “Test Data Source” to see if the connection is working. If not, check the above values. They have to appear as you see listed above. When you establish a connection, select “OK” and close the dialog box.
The default user names and passwords to access the report writing and cad programs are listed below.
Run the "Aleir.exe" file to run the report writing program. Run the "Cad.exe" file to run the dispatch program. Both of these files will be located in the "C:\Program Files\ALEIR" folder on your computer.
Return To A.L.E.I.R. Home Page
For More Information Email info@aleir.com