Error: Connector reply error: SQL##f - SqlState: 01000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]

[AlexJ]

Hi, 

In one Qlik app we call a SQL procedure (to update a table in SQL Server), and for some unknown reason we recently started getting the following error with a limited feedback. Any guidance how I should troubleshoot this? Thanks a lot in advance!

[SankarReddy]

Hi Alex,

SQL State '01000' is related to the connection failure. 

Is it the Qlik ODBC connector package or Native SQL ODBC driver?
If it is a Qlik ODBC connector, please check the connector log files folder path: "C:\ProgramData\Qlik\Custom Data\QvOdbcConnectorPackage\Log"
If it is a native ODBC driver, check the driver debug logs for more details from administrative tools ODBC tracing log.
Have you tested select queries directly? is it working fine?

Thanks,
Sankar.

[AlexJ]

Thank you for your answer, Sankar! It works without that procedure. I assume ODBC connection is fine if it loads. Noteworthy, the DB user has EXEC right on the procedure as well.

[SankarReddy]

Hi Alex,

You are correct, there is no problem with the connection. I tried with this script

SQL EXECUTE dbo.InsertInto 'USA' , 39613789 !EXECUTE_NON_SELECT_QUERY;

You also need to edit allow-nonselect-queries setting in the connector config file

  <add key="allow-nonselect-queries" value="true"/>

If it is not working, please feel free to create a support ticket for further investigation.

Best Regards,

Sankar.