Online Demo - MS Access / SQL Server Settings        print manager video

 

CZ Print Job Tracker 9.0 uses MS Access by default. You can also use SQL Server (including the free edition of SQL Server).  If you don't have a SQL server in your environment, you can download the free edition of SQL Server from Microsoft website (searching keyword "SQL Server Express" in Google). If you install CZ Print Job Tracker on multiple servers, each server can use it's own local database or connect to a central SQL database.

Step 1. In CZ Print Job Tracker Preferences --> Print Jobs, select "SQL Server", then click 'Configure' button.

Step 2. Enter the SQL server information, then click 'Create DB' button.  Click 'Connect' if it doesn't show "Connection OK".

  • SQL DB Name  This is the name of the database that stores data of printers, print jobs, users, client codes...

  • SQL Server Name  This is the name of the local or remote SQL server. If you install the free edition of SQL server (e.g. SQL Server 2005 Express Edition), the name may be like serverName\sqlexpress

  • SQL DB Directory  This is required when creating the database. Please check the location of database files (*.mdf) on your local or remote SQL server. The default locations of the database on different version of SQL Server are listed below. It should start with the disk driver (e.g C:\, D:\, E:\...)

  • SQL 2012              C:\Program Files\Microsoft SQL Server\MSSQL11.<instance_name>\MSSQL\Data\

                                   C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Data\

SQL 2008              C:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Binn\

                               C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Data\


SQL 2005              C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\


SQL 2000              C:\Program Files\Microsoft SQL Server\MSSQL\Data\

You can get the DB directory by right click your SQL server name in Object Explorer, select Properties --> General --> Root Directory and append "\Data" to the root directory.

 

or

SELECT name, physical_name AS current_file_location
FROM sys.master_files

Step 3. Click CZ Print Job Tracker menu Print Jobs -> Import (Access -> SQL Server) to import the print job data from MS Access to SQL database.

Common Issues:

1. SQL Server does not exist / access denied / connection failed / SQL Network Interfaces error: 26 - Error Locating Server/Instance Specified

a. Make sure your server name is correct.

b. Make sure your instance name (For example: SQLEXPRESS) is correct and there is actually such an instance on your target machine. 3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server. If not, try server IP.

c. Make sure SQL Browser service is running on the server.

d. If firewall is enabled on the server, you need to put sqlservr.exe (For example: C:\Program Files\Microsoft SQL Server\MSSQL.10\ MSSQL\Binn\sqlservr.exe) and sqlbrowser.exe (For example: C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe or C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe) and/or UDP port 1434 into exception.

e. For the remote SQL server, the "Allow remote connections to this server" needs to be selected, and TCP/IP protocols needs to be enabled

f. Place port number right next to sql server name for example: Test\sqlexpress,1433

2. Directory lookup for the file failed, or timeout expired

Please check the location of database files (*.mdf) on your local or remote SQL server. It should start with the disk driver (e.g C:\, D:\, E:\...)

3. 429 ActiveX component can't create object

If you install CZ Print Job Tracker on 64-bit Windows OS, please see the question 4.

The sqldmo.dll may not be registered correctly. Click Start --> Run --> regsvr32 sqldmo.dll. If this doesn't work, copy sqldmo.dll to c:\windows\system32 and copy sqldmo.rll to c:\windows\system32\resources\1033, then Click Start --> Run --> regsvr32 sqldmo.dll. If this still doesn't work, please see the question 4.

4. I have tried everything, but I still can't create database successfully. What else can I try?

a. Download the empty database file from http://www.czsolution.com/download/PrintSaver.zip . This database file includes all the tables and fields information.

b. Extract PrintSaver.zip that includes two files: PrintSaver.mdf and PrintSaver_log.LDF.

c. Copy PrintSaver.mdf and PrintSaver_log.LDF to the default SQL Data directory on the Server that hosting SQL Server. Please see above definition about SQL DB Directory.

d. Open Enterprise Manager (or SQL Server Management Studio).

e. Right click on Databases, choose All Tasks, Attach Database

f. Type in the path to PrintSaver.mdf file

g. Click on OK.

h. In CZ Print Job Tracker --> Preferences --> Print Jobs --> SQL Server --> Configure, click Connect.

5. The document name includes the question mark. How do I fix it?

a. On the computer that has CZ Print Job Tracker installed, go to control panel -> regional settings, set your language (it may require to restart the computer), then send a print job to test.

b. If step 1 doesn't work, rename C:\Program Files\CZ Solution\CZ Print Job Tracker\config\unic0 to unic, then send a print job to test.

 

Click   print manager video  to view the online demo

 

 

Download Print Management Software