Using OLE DB Adapter to Workaround ODBC 255 Character Field Limitation

Using OLE DB Adapter to Workaround ODBC 255 Character Field Limitation

book

Article ID: KB0073235

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight -

Description

ODBC Connections in TIBCO Scribe® Insight have a limitation of only allowing up to 255 characters in a field and truncating the characters after 255 when reading the data.

 

Resolution

Use the OLE DB TIBCO Scribe® Insight Adapter as a wrapper around the ODBC connection as this will allow 255 characters or more in a field and does not truncate any of the data. First you will need to set up the ODBC connection and then specify the ODBC connection name, username and password when setting up the OLE DB Adapter connection

See below on how to use the OLE DB Adapter
Adapter for OLE DB

 

Issue/Introduction

Using the OLE DB adapter as a wrapper for an ODBC connection in order to workaround the limitation of ODBC connections truncating fields that have more than 255 characters in TIBCO Scribe® Insight