Description

Invalid Column Type or Unexpected Column Types error from ODBC.

Explanation

The field type in the database was changed without reconnecting the field on the label to the re-defined column type in the database.

Solution

The following is a possible resolution.

  1. Reconnect the label fields to the database.
  2. Open Loftware Design and select Options | Preferences from the menu bar.
  3. Open the Advanced Options tree under Advanced ODBC, and select Allow all Column Types.

Related Articles

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.

Article Number

2009012 

Versions

Insert the versions of the LPS product.

All supported LPS family product versions

Environment

Enter environment configuration issues that can affect this issue.

Any supported LPS Family product environment

This table provides article information that is only visible to Loftware users.

Linked Jira 
Author 
Incident Number 
Article Number2009012 
Review Date7/14/2006