TraceParts help


System requirements Installation/Uninstallation Quick start Registration
Interface Configuration Use Advanced use
FAQ Troubleshooting Glossary  
 
 
Advanced use > Use a SQL Server


By default, TraceParts uses Microsoft Access databases for its operation.

It is possible to use databases on SQL Server instead for the following databases:
  • Parts Index
  • External base.
Notes :
    1. The installation and the use of the external base on a SQL Server are documented in the "external database links module" documentation. Please consult it. The following instructions will concern only the use of the SQL Server with the parts index.
    2. The "TPCustomInfos.mdb" customization base must remain in Microsoft Access format.

Prerequisite
    1. A SQL Server must be installed and configured (version 7 minimum).
    2. You must have access rights to this server.
    3. You must have installed TraceParts in complete version, and be administrator on this computer.


Operations to be carried out on the SQL Server

It will be assumed that the user is familiar with the use of a SQL Server.

Operations to be carried out:
  • Create a database called "PartsIndex" (or any other name of your choice).
  • Modify its properties so that the compatibility level is on "Database compatibility level 70"

Operations to be carried out on TraceParts
    1. Open a session as administrator.
    2. Start TraceParts.
    3. Go to the TraceParts tools/configuration menu.
    4. Select "Database".
    5. Check that the selected category is "Parts index".
    6. Open the "Type" drop-down list and choose "Microsoft SQL Server".
    7. Enter the name of the SQL Server to be used (without backslash "\\");
    8. Enter the name of the database created on the SQL server ("partsindex" for example). The configuration window will look like this:
    9. If an ID is required to access the SQL Server database, check the "Identification" box.
        1. Enter the user name
        2. Enter his password
    10. Validate the configuration changes by clicking "OK".
    11. A warning message will indicate that the parts index is not valid.
        1. Reply "Yes" (otherwise the modifications made above will be canceled and TraceParts will use the old parts index).
    12. A second warning will indicate that the index must be rebuilt (if running debug mode)
        1. Reply "Yes" (otherwise the modifications made above will be canceled and TraceParts will use the old parts index).
    13. TraceParts will then rebuild the parts index on the SQL Server.
    14. At the end of the update, TraceParts will use the parts index located on the SQL Server.

Configuration of TraceParts on the other network stations

Repeat the first 10 steps on the other workstations.
There will be no rebuilding of the index – the configuration change will be much quicker.

[ Back to the top ]