topic Re: Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida. in Data Movement & Streaming

Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida.

MikeD1 — Wed, 19 Mar 2025 22:43:16 GMT

Hi to all,

I configured an ODBC connection to SQL via Direct Access Gateway.

I visualize correctly all database tables but when select one of them I get the error in the object:

"Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida".

I tried to change some connection parameters but without success.

Someone could help?

Thanks in advance

Re: Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida.

jochem_zw — Mon, 20 Nov 2023 20:48:36 GMT

Please try to load only 1 field from this table to see if it is table related or column related.

Re: Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida.

MatteoBios — Tue, 12 Dec 2023 16:10:04 GMT

Hello, I have the same issue.

I can read all the db tables and also I can load them, but when I select one of them in the Data Connecton Preview I receive the error: Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida.

Can you help us?

Thanks,

Matteo

Re: Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida.

MikeD1 — Mon, 18 Dec 2023 10:13:01 GMT

Hi, I've solved using, in DataBase Specific Option -> SQL Sintax = SAP HANA SQL syntax

Re: Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida.

NadiaB — Thu, 04 Jan 2024 15:40:59 GMT

@MikeD1 that sounds right

Most issues related to Preview with Generic ODBC connections are due the connection missing the "Database specific options".

From the following Documentation, find the Data Source column and then the Syntax column that corresponds to your Data Source https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/ODBC-DrectAccess/sample-connection-strings.htm

Paste the value of the Syntax column under "SELECT statement template for Data Preview" in the Data Connection.

Adding a comment just in case someone come across this post.

Kind Regards.

Re: Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida.

hugo_andrade — Thu, 13 Jun 2024 15:10:27 GMT

Hi all,

Setting SQL Syntax = SAP HANA SQL fixed here as well.

Although my source is MS SQL, this SQL syntax did the trick.

Thanks @MikeD1 for sharing!

Re: Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida.

MikeD1 — Thu, 13 Jun 2024 15:28:15 GMT

You are very welcome!

Re: Command preview returned non-success: ERROR [HY090] [Microsoft][Driver Manager ODBC] Lunghezza della stringa o del buffer non valida.

MartijnWanders — Thu, 22 Jan 2026 12:45:10 GMT

Hi all,

The SAP Hana change solved the issue. I do not know why but thanks!