Back

Topic

[KB34]Compatibility problems with ODBC archiving

Tags: Archives

Historical data
16 years ago
By RM
Options
Print
Applies to:

PcVue version 7.20a onwards.
Summary:

This article describes how to deal with a change in the format of log tables for use with ODBC (Open DataBase Connectivity).
Details:

Due to developments for security (FDA 21CFR Part 11), the size of the User Name field was increased from 12 to 20 characters.

The problem occurs with a project that logs data to ODBC and that was developed with a version of PcVue earlier than 7.20a. Each attempt to record data in the log table displays an error message such as: Column type error

The work-around is as follows:

  • In the log table created by the relational DBMS, increase the size of the text field Username manually from 12 to 20 characters.

Created on: 01 Oct 2010 Last update: 13 May 2024