Using OLE DB Adapter to Workaround ODBC 255 Character Field Limitation
book
Article ID: KB0073235
calendar_today
Updated On:
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
Feedback
thumb_up
Yes
thumb_down
No