Rice Lake MSI-8000 RF Remote Display - ScaleCore 2 Database Program (Sc2Db) - Manual (Page 10)

6 ScaleCore 2 Database Operator’s Manual
5.2 Database Setup
The Sc2Db application requires a single schema named scalecoreprinter with a single table. The “create statement”
for the table is shown below:
CREATE TABLE `scprint` (
`id` int(10) unsigned NOT NULL,
`weight` double(12,6) NOT NULL,
`weightstring` varchar(12) NOT NULL,
`mode` varchar(8) NOT NULL,
`units` varchar(8) NOT NULL,
`captureTimeStamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Figure 5-1 shows the database as viewed from MySQL Workbench 6.0 CE.
Figure 5-1. MySQL Workbench 6.0 CE
5.3 MySQL ODBC Connection
The Label Matrix 2012 PowerPro software requires an ODBC database connection. The following steps should help
in configuring MySQL ODBC connection. For complete details and additional support, please see the MySQL
documentation.
1. Start the ODBC Data Source Administrator.
- Access Control Panel
- Select System and Security followed by Administrative Tools
- Select the shortcut for Data Sources (ODBC)
- For 64-bit systems, you may have to access: C:\Windows\SysWOW64\odbcad32.exe
- A dialog similar to Figure 5-2 should display.