Printronix PrintNet Enterprise User Manual
Page 301
Example Exporting Telemetry Data To A Microsoft Access Database
301
Figure 260. Adding Fields Using Design View in Microsoft Access
5.
Name the next three fields
CaptureDate
,
FailureCode
, and
DecodedData
, and define them as
Text
data types. See Figure 260.
NOTE:
Beginning with the second field, the field names must match the order
of the fields specified in the OdvJdbcDbFields property. In this
example, the OdvJdbcDbFields would be defined as
OdvJdbcDbFields=CaptureDate,FailureCode,DecodedData.
6.
Save the table as
events
.
7.
Save the database as
odv
.
8.
Open the Control Panel and double-click
Data Sources
(ODBC)
.
NOTE:
In Windows
®
2000, double-click
Administrative Tools
, then
Data
Sources (ODBC)
.
In Windows XP, click
Performance and Maintenance
, then
Administrative Tools
, then
Data Sources (ODBC)
.
9.
Click the
System DSN
tab.
10. Click
Add
to create a new System DSN (Data Source Name) entry.
This way the database can be accessed by the AutoID Data Manager
running on a workstation that is not running the database.
11. Select
Microsoft Access Driver
from the driver list and click
Finish
.
(If the driver is not listed, you need to install the driver before continuing.)