TIBCO Scribe® Insight Adapter for OLE DB errors when creating connection - "Object reference not set to an instance of an object"

TIBCO Scribe® Insight Adapter for OLE DB errors when creating connection - "Object reference not set to an instance of an object"

book

Article ID: KB0074716

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight -

Description

When attempting to create a connection in the TIBCO Scribe Insight Workbench using the Adapter for OLE DB results in error: "Object reference not set to an instance of an object" from Scribe.OLEDBAdapter.dll.

This error is generated because a parameter being set in the connection is not valid. In most cases a mistake is made when populating the Data Source field in the OLE DB connection. The Adapter requires a ODBC System DSN name to be entered in the Data Source field. Sometimes server names or other incorrect values are entered by mistake resulting in the error.

Issue/Introduction

When attempting to create a connection in TIBCO Scribe Insight Workbench with the Adapter for OLE DB results in error: "Object reference not set to an instance of an object" from Scribe.OLEDBAdapter.dll.

Resolution

To resolve the issue, create a new System DSN ODBC connection on the Scribe Insight Server. Then when creating the OLE DB connection use that new ODBC DSN name in the Adapter for OLE DB connection properties.

Below are the steps to create a ODBC System DSN connection.
  1. Go to Control Panel > System and Security > Administrative Tools > ODBC Data Sources(32 bit).
  2. From the ODBC Data Source Administrator window choose the System DSN tab.
  3. Click Add to create a new ODBC connection and create the new connection to the endpoint. 
  4. After creating the new System DSN successfully, configure the Adapter for OLE DB using the new DSN name as the Data Source field value.
Powered by Wolken Software