Configuration for MS SQL Server 2000
Configuration for MySQL

Configuration for MS SQL Server 2000

To have the printing journal stored in MS SQL Server 2000, do the following:

1.Create a database in the destination MS SQL Server 2000.

2. Run a script mssql_pmonitor.sql on the server for just created database. The script resides in Database \ MSSQL subfolder of PrintMonitor folder. As a result, there will be new tables created for printing journal storage as well as service tables for the application.

3. Start PrintMonitor viewer. Connect to the just created database. To connect, select File/Connection. In the dialog box select an entry "Microsoft SQL Server" in "Data source" dropdown combo box list. Specify connection settings to the server and press "OK" button.

If the application was able to connect successfully, it will open a reports tree on the left side of the main window.

4. To configure the monitoring service of PrintMonitor, go to Tools/Settings, select "MS SQL Server" tab and specify connection parameters to the server.

5. Select "Databases" tab on the Settings dialog. Set a check for "MS SQL Server" entry in the list and press "Apply" button.

6. Restart the monitoring service. To restart the service you can use a menu entry Tools/Service/Restart service or use standard operating system Services manager (Administrative Tools/Services).

Configuration for MySQL

Attention! For proper working of PrintMonitor 3.x with MySQL server you need to install MySQL ODBC 3.51 Driver.

To have the printing journal stored in MySQL database, do the following:

1. Create a database in the destination MySQL server.

2. Run a script mssql_build_base.sql on the server for just created database. The script resides in Database \ MySQL subfolder of PrintMonitor folder. As a result, there will be new tables created for printing journal storage as well as service tables for the application.

3. Create a system DSN in the Data Sources (ODBC) configuration utility: go to Start/Settings/Control Panel/Administrative Tools/Data Sources (ODBC), select "System DSN" tab and press "Add" button. In the opened dialog select MySQL ODBC 3.51 Driver and press "Finish". On the next dialog specify required connection parameters to MySQL server. Enter "printmonitor' into "Data Source Name" edit box. Leave the rest of the edit boxs unchanged.

4. Run PrintMonitor viewer. Connect to the just created database. To connect to the database, select File/Connection menu. In the opened dialog select "MySQL" entry in dropdown combo box, set required connections parameters and press "OK".

If the application was able to connect successfully, it will open a reports tree on the left side of the main window.

5. To configure the monitoring service of PrintMonitor, go to Tools/Settings, select "MySQL Server" tab and specify connection parameters to the server.

6. Select "Databases" tab on the Settings dialog. Set a check for "MySQL" entry in the list and press "Apply" button.

7. Restart the monitoring service. To restart the service you can use a menu entry Tools/Service/Restart service or use standard operating system Services manager (Administrative Tools/Services).

Press OK to save all changes.