Resolving labware inventory problems
About this topic
This topic describes how to check and test the database connection that is used by the VWorks inventory management system.
Checking the database settings
The inventory database uses a Windows Open Database Connectivity (ODBC) interface. If you encounter inventory management problems, you may need to check the database settings.
To check the database settings:
1 Open the ODBC Data Source Administrator as follows:
In the C:\Windows\SysWOW64 folder, right-click odbcad32.exe, and then select Run as administrator.
 |
2 In the ODBC Data Source Administrator (32-bit) dialog box:
a Click the System DSN tab.
b Select the VWorksInventory data source, and then click Configure.
 |
The MySQL Connector/ODBC Data Source Configuration dialog box opens.
 |
3 Verify the following settings:
Connection Parameters | Settings |
|---|---|
Data Source Name | VWorksInventory |
Description | (optional) VWorks Inventory database |
TCP/IP Server | localhost |
User | |
Password | |
Database | velocity11 |
Testing the connection
To test the database connection:
1 In the MySQL Connector/ODBC Data Source Configuration dialog box, set the User and Password as follows.
Connection Parameters | Settings |
|---|---|
User | vworks |
Password | vworks |
2 Click Test.
3 When the Connection Successful message appears, click OK.
 |
4 In the Connection Parameters area, clear the User and Password fields, as the following figure shows, and then click OK.
Note: The VWorks software will specify the user name and password, so, you must clear the User and Password fields after testing the connection.
 |
5 Click OK to close the ODBC Data Source Administrator (32-bit) dialog box.
 |
Related information
For information about... | See... |
|---|---|
Inventory groups, plate groups and location groups | |
Moving labware in and out of a storage device | |
Changing the labware associated with plates in the inventory database | |
Inventory Editor filters |