https://community.qlik.com/t5/Connectivity-Data-Prep/QlikCloud-Impossible-to-load-data-from-an-HFSQL-database-windev/m-p/2535650#M15288 <P><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I try to setup a connexion from an HFSQL database in a qlikcloud environnement.</SPAN><BR /><SPAN>The QlikDataGateway is correctly installed, and the appropriate driver is available on the QDG Server.</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>Now, in a qlik application. i created a connexion :</SPAN><BR /><SPAN>- I chose the appropriate driver in the dropdown</SPAN><BR /><SPAN>- In Database specific properties, i chose "Custom SQL syntax"</SPAN><BR /><SPAN>- when I clic on Detect button, the field Database and owner have filled up</SPAN><BR /><SPAN>- then i create the connexion.</SPAN><BR /><BR /><SPAN>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'.</SPAN><BR /><BR /><SPAN>I think there are some missing parameters in the Database specific properties part but i don't know what exactly.</SPAN></P><P><SPAN>Does anyone know the correct settings for this type of database?</SPAN></P> Fri, 07 Nov 2025 16:29:04 GMT estellecorbin 2025-11-07T16:29:04Z https://community.qlik.com/t5/Connectivity-Data-Prep/QlikCloud-Impossible-to-load-data-from-an-HFSQL-database-windev/m-p/2535650#M15288 <P><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I try to setup a connexion from an HFSQL database in a qlikcloud environnement.</SPAN><BR /><SPAN>The QlikDataGateway is correctly installed, and the appropriate driver is available on the QDG Server.</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>Now, in a qlik application. i created a connexion :</SPAN><BR /><SPAN>- I chose the appropriate driver in the dropdown</SPAN><BR /><SPAN>- In Database specific properties, i chose "Custom SQL syntax"</SPAN><BR /><SPAN>- when I clic on Detect button, the field Database and owner have filled up</SPAN><BR /><SPAN>- then i create the connexion.</SPAN><BR /><BR /><SPAN>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'.</SPAN><BR /><BR /><SPAN>I think there are some missing parameters in the Database specific properties part but i don't know what exactly.</SPAN></P><P><SPAN>Does anyone know the correct settings for this type of database?</SPAN></P> Fri, 07 Nov 2025 16:29:04 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/QlikCloud-Impossible-to-load-data-from-an-HFSQL-database-windev/m-p/2535650#M15288 estellecorbin 2025-11-07T16:29:04Z