Qlik DataGateway Direct Access Error SQLSetStmtAttrW

[DaanBrand1988]

Hi, 

When setting up a Qlik Data Gateway ODBC connection i receive the following error

ERROR [UNIT4] SQLSetStmtAttrW: driver does not support setting attribute values on a statement handle; the specified attribute value will be ignored.

We are using the Multivers Online ODBC-driver (Download 64bits Online ODBC driver 1.1.1.0 (msi)

When setting it up we get a Connection Succeeded message.

We try to select the data we see the meta data and the structure of the tables. 

But then we got the error, see below

Any Idea?

[Chip_Matejowsky]

Hi @DaanBrand1988,

I have seen similar issues resolved by configuring Database Specific Option > SQL syntax > in the Create data connection. Refer to this previous Community thread and Qlik Help entry Sample connection strings and syntax for further details.

Best Regards

[roelvandeven]

Hi @DaanBrand1988,

Did you get the connection to work?
I have the same issue and can't seem to find the right settings to connect to Multivers via the Data Gatewat.

Kind regards,

Roel