Printronix PrintNet Enterprise - Manual (Page 300)

300
Chapter 7 Telemetry Data Export To 3rd Party Databases
Microsoft
®
Access™
OdvJdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver
OdvJdbcUrl=jdbc:odbc:odv;UID=odvuser&PWD=odvpassword
OdvJdbcDbName=events
OdvJdbcDbFields=CaptureDate,FailureCode,DecodedData
NOTE: Date is a reserved word in Microsoft Access.
Microsoft Excel
OdvJdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver
OdvJdbcUrl=jdbc:odbc:odv
OdvJdbcDbName=[Sheet1$]
OdvJdbcDbFields=CaptureDate,FailureCode,DecodedData
Example Exporting Telemetry Data To A Microsoft
Access Database
This example shows how to create an Access database, connect it to the
AutoID Data Manager, and have the AutoID Data Manager export captured
telemetry data to the database.
To create an Access database:
1. Open Microsoft Access.
2. Select File New Database to create a new database named odv .
(Use the Blank database template.)
3. Click New to create a new table. Select Design View .
4. Name the first field ID and define it as an AutoNumber field. This is
required since the database must have a unique key value for each
record. Each record sent from the AutoID Data Manager will be appended
to the database and the data in this field will be one greater than the value
in the previous record.