topic Re: Qlik DataGateway Direct Access Error SQLSetStmtAttrW in Connectivity & Data Prep

Qlik DataGateway Direct Access Error SQLSetStmtAttrW

DaanBrand1988 — Fri, 28 Mar 2025 11:35:31 GMT

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?

Re: Qlik DataGateway Direct Access Error SQLSetStmtAttrW

Chip_Matejowsky — Mon, 07 Apr 2025 16:27:14 GMT

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

Re: Qlik DataGateway Direct Access Error SQLSetStmtAttrW

roelvandeven — Fri, 13 Jun 2025 15:18:45 GMT

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