Good afternoon, running Query Tool Beta 20.1.537 After making a ODBC connection with AES(Sybase) server , I am in front of very dirty data set that QueryTool won’t let pass because of the real data Data Type not following the table column data type. [Error itgenrst004 on ODBC] For example a Bigin…

The issue is closed on our side we have managed to overcome by skiping data that fall in this case. If you want to analyse for improvement of Invantive engine, we may be able to provide access to the old solutions, I think we didn’t shut off the old software yet.

Itgenrst004: The type of actual data must match / QueryTool 20.1.537 / Boolean datatype expressed as int64 from ODBC connector

Questions

sda 8 september 2021 om 16:27 3

Sorry for my bad Dutch… it seems a boolean

After more digging it seems that all table that contains datatype boolean are not correctly handled by QueryTool via ODBC… is that possible ?

Topic		Antwoorden	Weergaven
Query Tool / Oracle : itgenefd016: Scale is set while precision isn't Questions invantive-query-tool , oracle	11	973	20 september 2023
Itgenrst046: Aroutstandingitemsex@eol date UTC data type issue Questions invantive-query-tool , exact-online	4	398	11 april 2024
Itgenase308: The platform vendor-specific driver can not handle the value returned for the column XXX of data type 'numeric' Questions invantive-query-tool , postgresql	2	553	20 september 2023
Itgenrst004 issue with nativeplatformscalarrequests@eol Questions invantive-query-tool , exact-online	3	119	21 maart 2024
Itgenrst004: Der Typ der eigentlichen Daten muss mit dem Datentyp der Spalte 'Adressnummer' in '' übereinstimmen Questions sql-server , invantive-sql	2	265	7 november 2023

Itgenrst004: The type of actual data must match / QueryTool 20.1.537 / Boolean datatype expressed as int64 from ODBC connector

Gerelateerde topics