Invalid Column Type or Unexpected Column Types error from ODBC.


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


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



Insert the versions of the LPS product.

All supported LPS family product versions


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 
Incident Number 
Article Number2009012 
Review Date7/14/2006