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:
- Incorrect TMS configuration; check the server name with your local IT department and correct it with the DbConnectCfg.exe program (supplied with TMS).
- 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'.
- 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.
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.
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.
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:
- 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.
- 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.
Cause: 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].
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.
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:
- 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.
- 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.