Forum Discussion
Query Timeout Setting: Online Services
Does anyone know where timeout settings might be increased for Online Services queries?
A Registry setting, for example, like with Access to SQL using ODBC/Jet.
I'm pulling in Salesforce ...
Absent suggestions on how to increase the OLE DB timeout for SalesForce objects, here's a way to cycle through each query, waiting for each to complete, and get feedback that the query was successful:
'Query names are listed on worksheet(WS)
For i = 2 To lastrow
strQ = "Query - " & WS.Range("A" & i).Text
ThisWorkbook.Connections(strQ).Refresh
'Wait until SalesForce Query has completed before moving to next step
Application.CalculateUntilAsyncQueriesDone
'Record results by counting OLEDB Errors (0 is successful update)
Debug.Print strQ & ": " & Application.OLEDBErrors.Count
Next i
'Query names are listed on worksheet(WS)
For i = 2 To lastrow
strQ = "Query - " & WS.Range("A" & i).Text
ThisWorkbook.Connections(strQ).Refresh
'Wait until SalesForce Query has completed before moving to next step
Application.CalculateUntilAsyncQueriesDone
'Record results by counting OLEDB Errors (0 is successful update)
Debug.Print strQ & ": " & Application.OLEDBErrors.Count
Next i