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

[agigliotti]

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

[andrea_beschi]

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

[amorgado]

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

[johanlindell]

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.