LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Database toolkit & Oracle 11g, problem with timestamps

I tested my application, based on the Database toolkit, with Access and Oracle XE (10g) databases and all was ok. After moving my database to a Oracle 11g server, i get this error for any query involving a TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH LOCAL TIME ZONE column:

 

ADO Error: 0x80040E21
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: ODBC driver does not support the requested properties.

 

The error is raised by the "Execute" invoke node in "DB Tools execute query.vi".

Using Labview 2009 and up to date Oracle ODBC drivers on Windows XP

0 Kudos
Message 1 of 2
(2,865 Views)

Hi SnamProgetti,

I don't have any useful information about this error. You can try to read this and this document.

 

Have a nice day,

______________________
Simone S.
Academic Field Engineer - Med Region
0 Kudos
Message 2 of 2
(2,823 Views)