ODBC Driver Timeout using System.Data.Odbc in Visual Studio

[Ian23]

Hi,

I am creating a small C# app to pull data from our instance in to our reporting database and receive the following error after 55 seconds:

'ERROR [HYT00] [SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Query Timeout expired[10246]'

The SQL command is below and should return < 9000 records. If I run the SQL in the interactive SQL shell it completes.

Has anyone run across this issue before? 

SELECT  sn_customerservice_case.number  
	, sn_customerservice_case.opened_at  
	, sn_customerservice_case.resolved_at  
	, sn_customerservice_case.dv_business_service AS Business_Service   
	, sn_customerservice_case.business_service AS Business_Service_ID   
	, sn_customerservice_case.dv_service_offering AS Service_Offering   
	, sn_customerservice_case.service_offering AS Service_Offering_ID   
	, sn_customerservice_case.dv_assignment_group AS Assignment_Group   
	, sn_customerservice_case.dv_priority AS Priority   
	, spm_taxonomy_node.name AS Taxonomy_Node   
	, spm_taxonomy_node.dv_parent AS Taxonomy_Node_Parent   
	, spm_taxonomy_node.sys_id AS Taxonomy_Node_ID   
FROM 
	(sn_customerservice_case sn_customerservice_case
	INNER JOIN
	cmdb_ci_service cmdb_ci_service
	ON (sn_customerservice_case.business_service = cmdb_ci_service.sys_id))
	INNER JOIN
	spm_taxonomy_node spm_taxonomy_node
	ON (cmdb_ci_service.spm_taxonomy_node = spm_taxonomy_node.sys_id) 
WHERE (((spm_taxonomy_node.dv_parent  = 'PARENT NAME' AND sn_customerservice_case.dv_state  <> 'Canceled') AND sn_customerservice_case.opened_at  <= '2022-09-30 23:59:59') AND (sn_customerservice_case.resolved_at  IS NULL OR sn_customerservice_case.resolved_at  > '2022-09-30 23:59:59'))