From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Logging Result to Data Base

I tried to logging to the Oracle data base from TestStand.
and I got an error:
An exception occurred calling 'LogResults' in 'ITSDBLog' of 'DBLog 1.0 Type Library'
An error occurred while setting a column value.
Schema: Oracle 8 (NI).
Statement: STEP_RESULT.
Column: ID.
Object was open.
Source: TSDBLog

-2147217915; User-defined error code.

I am using the NI schema for Oracle8
Do you know what is the problem ???
0 Kudos
Message 1 of 3
(2,823 Views)
To header -
I have never been able to reproduce this error before when another customer described it, but when the customer upgraded the Oracle client software to the latest ODBC driver or OLE-DB provider, the problem went away. I think that they used ODBC instead of the OLE-DB Provider. You should be able to use version 8 or 9 client software on a client system to communicate to a 8 server. I have tested are 8.1.7.6.0 ODBC driver and the 8.1.7.2.0 OLE-DB driver that you can get from Oracles web site.

Scott Richardso (NI)
Scott Richardson
0 Kudos
Message 2 of 3
(2,823 Views)
To all who read this post:

The user's problem was solved by upgrading to Microsoft Data Access Components (MDAC) v2.7 available at the following web address:

Link -> http://www.microsoft.com/data/download.htm

Jason F.
Applications Engineer
National Instruments
www.ni.com/ask
Message 3 of 3
(2,823 Views)