What Does Error -2147467259 Mean When Connecting to an Oracle Database?

Updated Jan 24, 2018

Reported In

Software

  • LabVIEW Database Connectivity Toolkit
  • LabVIEW

Issue Details

I have an application that requires me to connect to an Oracle Database. When I try and update a table in Oracle, I get Error -2147467259 from the DB Tools Insert Data VI. I have the latest version of the Oracle ODBC driver. What does this error mean, and how can I send data to Oracle from LabVIEW?

Solution

The DB Tools Insert Data VI expects a cluster of data to be connected to the data input. You must have each variable in the cluster defined to be the appropriate data type. If you have all entries in the cluster defined as strings and the Oracle table is expecting numerics, you will receive the error message:

Error: -2147467259 
expecting a number but receiving a binary


Also, be sure to use the DB Tools Format Datetime String VI from the Utilities sub-palette to correctly format any date or time entries that you need to send to the Oracle database.

WAS THIS ARTICLE HELPFUL?

Not Helpful