Support Contact OSO OSO website

Key features
Related products

This page describes events and questions that you might encounter when you first start using TMS. If you have a specific question you best e-mail us via the TMS e-mail support request option. This mail includes some technical information about your specific TMS version and configuration and this helps us to address your problem better.

Another option is to use our remote support program that enables us to view your desktop and take control of your PC. We require your permission for each step (view, control, file transfer) of the remote support connection.
TMS v2.6+ has this functionality build in. To use it select Help-->Support--Start Remote Support and contact OSO.




When I start TMS I get the message 'SQL Server ... is not know to be running. Do you want to connect anyway?'


TMS checks whether the configured SQL Server is running or available and if this is not the case you get this message. Unavailability of the SQL Server running your TMS database can be caused by the following:

  1. Incorrect TMS configuration; check the server name with your local IT department and correct it with the DbConnectCfg.exe program (supplied with TMS).
  2. The SQL Server name is correct but the service is turned off (can be the case with a locally installed MSDE). In this case TMS can start SQL Server when you start TMS. Use the DbConnectCfg.exe program and set the option 'Start SQL service with application'.
  3. The configuration is correct but the LAN or the SQL Server is down. Contact your local IT department to report the problem and wait until they have solved it.


When I start TMS message 'Error# -2147024891 in OSOSQLL@TSQLServer::ServerStart(). [SQL-DMO] Service control error: Access Denied' appears. But when I click [OK] everything works just fine.

Your TMS configuration has the option 'Start SQL service with application' enabled but your UserID is not allowed to start or stop the SQL Service. Turn off the 'Start SQL service with application' option with the DbConnectCfg.exe program.



The 'Cannot open database ... Login fails' message appears a few times and finally TMS doesn't start.

Your TMS configuration has been set to a TMS database (in the screenshot TMSFEP) that either doesn't exist or that you don't have access to. Make sure the database name is correct and that your UserID, direct or indirect via a security group, has been granted access to the SQL database and is part of the TMSUserRole.



TMS <--> database version mismatch

At start-up TMS checks it's program version against the version stored in the TMS database. If the major and minor version numbers do not match you get the message above. TMS checks these numbers to prevent users from working with older or newer software than the database is designed for. This prevents weird error messages and program crashes and, in a worst case, even data corruption. When you upgrade the software you must also upgrade the database and vice versa. Contact Object Software on how to resolve this.


How to reset TMS to its initial settings

When you start the TMS with the command line parameter /setdefaults or /sd (for example c:\program files\TMS\tms.exe /sd) it triggers the procedure that will delete all custom TMS settings on your workstation and enter default values into the TMS database.

Please note that your default lend time will be reset to 720 hours (=30 days) and the numeric employee code padding length is reset to 6 positions. The usage statistics will also be reset.

Use this parameter only when for instance TMS crashes due to a corrupt registry or when someone (not using TMS) has deleted system types like 'STOCK' and 'Undefined'.


How to re-register a TMS license

My company has increased the number of workstation licenses but how do I install this new license?

When TMS is first started the software prompts for the registration name and activation code. To change the registration name/activation code afterwards (after it has been registered in the past) you can start the program with the command line parameter /register or /r (for example c:\program files\TMS\tms.exe /register). It will then again prompt for the registration name and code.


Barcode reader error 122:0 During reader access. Not connected!

When you want to transfer data from the Formula barcode reader to TMS you get the message 'Error 122:0 During reader access' and then the message 'Not connected' and nothing is transferred.

When you get this message TMS cannot communicate with your barcode reader. The following can cause this:

  1. Most likely you have selected the wrong COM port. Select File>Configuration, tab 'Barcode', section 'Reader' and check the COM port. It must be set to the port the cradle has been connected to. Also check the speed setting: this must be set at 9600.
  2. The cradle is turned off. When the led on the cradle is not lit green or red it is turned off. Turn it on with the on/off switch on the right side.

Barcode labels and reports don't show barcodes

Problem: When you print a barcode label or a report containing barcodes like the 'Barcode list of lends per employee' report, no barcodes are shown. Only the code itself with a rather large fontsize.
: In some cases the installation program doesn't register the Code 3 of 9 barcode font properly.

Solution: reinstall the barcode fonts using the control panel fonts section. Choose 'install new font' from the menu and browse to the \Additional\Fonts folder of the TMS installation CD. Check the 'copy font to windows fonts directory' option and click [install].


How do I lend or issue tools without a barcode reader?

You can move around tools using drag and drop. To lend a tool open the 'lendings overview' screen and select the person you want to lend the tool to. Now open the stock overview and select the tool you want to lend. Now click and the tool and drag it over to the lend to ... listbox that contains the tools the person you want to lend the tool to and drop it into that window. TMS will request a confirmation for the move. Click [OK]. If the tools is not serialized you can now enter the number of items you want to lend.

To return a tool you can use the same drag and drop method but you can also click on the [Return] button to return it to stock.


How to remove barcode reader junk transactions

In the first weeks after TMS is introduced people tend to scan all sort of things with the barcode scanner. They also will make more mistakes in the beginning and that results in a lot of bogus transactions.

People will always make mistakes while working with the barcode readers and the TMS itembag screen will help you solve these errors as much and easy as possible. One of the features is the 'blanks' or garbage filter option where TMS will check all transferred barcode transactions and judge whether a transaction is (partly) valid or not. In this way blank and bogus transactions can be removed with a few mouse clicks after which you can focus on the real mistakes that have been made.

To use the blanks option: After barcode transactions transfer, select the [Blanks] button on the button bar on the right of the Itembag screen. Deselect the transactions that you want to keep by clicking on the checkbox before each line. Click [Discard] in the toolbar to delete the selected bogus transactions.


How to print barcodes for multiple tools at once?

With TMS you can easily print a barcode label for a tool. Select the tool you want the label for and click on the [Barcode] button in the toolbar. Or when you add a tool to the stock - using 'Add items to stock' - you can immediately print a barcode label for the tool you just added. This will give you one barcode at the time.

But you can also print a series of barcode labels in one go. This comes in handy when you start labelling your tool shop for the first time or have to renew labels. There are two ways to do this:

  1. Per product: from the product overview, click the [Barcode] button.
    When the product is non-serialized you get just one barcode label. When it is a serialized product however a sub-menu appears that allow you to print only the product code or the selected serial numbers.

  2. Per storage location: Select Manage>Items per storage location.
    This will show you an overview of all the tools per storage location regardless of its current assignments. Select a storage location in the right panel then select the tools you want print barcode labels for in the left panel. Click the [Barcode] button; if more than one tool is selected you get a warning that you will print the selected number of labels. When you click [OK] the labels will be printed.



• Home • Key features • History • Related products • Support • Downloads •

Copyright 2008 Object Software Ontwikkeling BV. All rights reserved.
Last update: donderdag 22 mei 2008.