topic Re: Error in selecting data for ODBC database using Qlik Data Gateway direct access in Connectivity & Data Prep

Error in selecting data for ODBC database using Qlik Data Gateway direct access

agigliotti — Thu, 12 Oct 2023 15:16:07 GMT

Hi,

I'm facing the below error, trying to select database table using Qlik Data Gateway direct access.

ODBC source: iSeries Access ODBC Driver

Connection string: System=XXX;Uid=YYY;Pwd=ZZZ;

Test connection is ok

Also the manual select in DLE works correctly.

Can someone help me to fix it?

Many thanks in advance for your time.

Best Regards

Re: Error in selecting data for ODBC database using Qlik Data Gateway direct access

andrea_beschi — Mon, 16 Oct 2023 14:25:09 GMT

Hello,

Same error here:
ODBC Driver 17 for SQL Server
Connection String Server=ZZ;UID=AA;PWD=BB;
Connection Test ok
Trying to open Data Selection end with error
"Command collection returned non-success: The given key 'DatabaseTerm' was not present in the dictionary."

Thanks

Re: Error in selecting data for ODBC database using Qlik Data Gateway direct access

amorgado — Fri, 17 Nov 2023 17:42:29 GMT

Hi,

I'm having a similar problem. I have a connection (odbc via Direct Gateway Access) to a pervasive sql database with success in the connection, but when I try to load data from the tables I get this error message.

"Command fields returned non-success: The driver used does not comply with the general database column specification. Returned columns metadata does not contain COLUMN_SIZE, DECIMAL_DIGITS fields"

Any ideia? what might be happening.

Thanks

Best Regards

Re: Error in selecting data for ODBC database using Qlik Data Gateway direct access

johanlindell — Wed, 31 Jan 2024 12:43:35 GMT

Had the same problem, "Command collection returned non-success: The given key 'DatabaseTerm' was not present in the dictionary.". After configuring the Custom SQL syntax for Pervasive this error is fixed but then the same problem as Amorgado is shown.

Re: Error in selecting data for ODBC database using Qlik Data Gateway direct access

ptpaspuel — Tue, 10 Sep 2024 16:19:41 GMT

Hi,

have you fix this issue?

Re: Error in selecting data for ODBC database using Qlik Data Gateway direct access

sheavero — Wed, 07 May 2025 18:13:41 GMT

Hello,

How did you resolve this?

Re: Error in selecting data for ODBC database using Qlik Data Gateway direct access

amorgado — Wed, 07 May 2025 19:13:34 GMT

No solution so far, at least for me.

Re: Error in selecting data for ODBC database using Qlik Data Gateway direct access

agigliotti — Thu, 08 May 2025 08:10:24 GMT

Unfortunately I just retried again now and same error...