Automated Police Systems,
Inc.Automated Police Systems,
Inc.
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.40. If you are using an older version of the "Aleir.exe" file, you can download the latest version without the Windows installer from here.
After successfully installing the report writing program, you will need to download and install MySQL Server on a computer on your network. Make sure you download and install MySQL version 5.0 on your computer.
MySQL Server will hold all of the data entered into the report writing program. You will need to read the instructions on the MySQL Website to learn how to install the MySQL Server.
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\rptdata" 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.
The next step is to add a user to the MySQL Server so you can log into the MySQL Server. You can find instructions on how to add a new user to the MySQL Server here. You will want to add a new user account having the following values. You will need to give this account the following privileges on the table named "rptdata": Select, Insert, Update and Delete
After successfully installing the MySQL Server on your network, you will need to install the MySQL Connector/ODBC 5.1 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 5.1 Driver", select the “Finish” command button and a new window will appear named “MySQL ODBC 5.1 Driver – DSN Configuration, Version 5.5". 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. Next you will need to configure a couple of options so select the "options >>" command button. You will need to check the option "Don't Optimize Column Width" and check the option "Return Matching Rows" in the dialog box. Your options should look like this when you are finished.
The default user names and passwords to access the report writing program are listed below.
If you are going to use this program on the Internet, you should encrypt your data. There are several ways to do this. My recommendation is to use Stunnel to encrypt the connection between the MySQL Server and your workstations. You can download Stunnel from the Internet.
Return To A.L.E.I.R. Home Page
For More Information Email info@aleir.com