Forum Discussion

Michael Doukas's avatar
Michael Doukas
Copper Contributor
Dec 15, 2017

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 objects using Get and Transform in Excel 2016 Pro.

 

TIA!

BI & Data Analytics
tips and tricks

1 Reply

  • Michael Doukas's avatar
    Michael Doukas
    Copper Contributor
    Jan 05, 2018
    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