beautypg.com

Printronix PrintNet Enterprise User Manual

Page 301

background image

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.)