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

[MikeD1]

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

[jochem_zw]

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

[MatteoBios]

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

[MikeD1 · Accepted solution]

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

[NadiaB · Accepted solution]

@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/OD...

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. 

[hugo_andrade]

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!

[MikeD1]

You are very welcome!