QlikCloud : Impossible to load data from an HFSQL database (windev) with an ODBC Direct Access connexion
Hi,
I try to setup a connexion from an HFSQL database in a qlikcloud environnement. The QlikDataGateway is correctly installed, and the appropriate driver is available on the QDG Server. When i test a connexion with this driver outside Qlik Environnement (in an excel file), i can retrieve data. So i believe the driver part is ok. Now, in a qlik application. i created a connexion : - I chose the appropriate driver in the dropdown - In Database specific properties, i chose "Custom SQL syntax" - when I clic on Detect button, the field Database and owner have filled up - then i create the connexion.
When i want to use this connexion, the database part is ok, but the dropdown in Owner field are all white just as the table list (not empty, but white...) . And when i select ( blindly) a table, i have this error 'Command tables returnes not success : Arithmetic operation reulted in oberflow'.
I think there are some missing parameters in the Database specific properties part but i don't know what exactly.
Does anyone know the correct settings for this type of database?
