topic ODBC SQL Server time out in Connectivity & Data Prep

ODBC SQL Server time out

LHSC — Wed, 30 Mar 2022 17:07:24 GMT

Hi everyone,

We're getting a time out error connecting to our SQL Server database through ODBC.

The ODBC setup on the workstations are fine. Within in report, report tries to connect, times out, then the SQL Server login box. Click ok and everything loads good.

I'm thinking I just need to extend the connection time. Are we able to do that?

Thanks

Re: ODBC SQL Server time out

Jack_Guo — Thu, 07 Apr 2022 03:16:17 GMT

Hi @LHSC ,

This post may help you to change the timeout time for ODBC connects to SQL Server.

https://community.qlik.com/t5/App-Development/Qlik-Sense-Timeout-loading-data-from-SQL/td-p/1219179

I hope this helps.

Re: ODBC SQL Server time out

KIRTHI — Fri, 07 Jun 2024 11:21:41 GMT

I am looking for the timeout parameters that helps with connection

Error message:

[SOURCE_CAPTURE ]E: SqlStat: HYT00 NativeError:0 [Microsoft][ODBC Driver 17 for SQL Server]Query timeout expired (PcbMsg: 63) [1020102] (sqlserver_log_processor.c:4304)

[SOURCE_CAPTURE ]E: Unknown '0' native error detected while SQL_ERROR is flagged / SQLSTATE is not empty. [1020102] (sqlserver_log_processor.c:4305)

[SOURCE_CAPTURE ]E: Encountered an unexpeceted error. [1020102] (sqlserver_endpoint_capture.c:1043)