<div>
I'm guessing that your VBA is using an ODBC connection. Br default this has a timeout of 60 seconds. Generally, you can alter this in the registry to a higher value. I'm not sure if you're using Excel or Access to run this against SQL Server<br />
<br />
<br />
Kelvin
</div>


I'm guessing that your VBA is using an ODBC connection. Br default this has a timeout of 60 seconds. Generally, you can alter this in the registry to a higher value. I'm not sure if you're using Excel or Access to run this against SQL Server


Kelvin

<div>
Have look at this. Look like you can set this in Excel<br />
<br />
<a href="https://msdn.microsoft.com/en-us/library/office/aa224907%28v=office.11%29.aspx?f=255&MSPPError=-2147217396" rel="ugc">https://msdn.microsoft.com/en-us/library/office/aa224907%28v=office.11%29.aspx?f=255&MSPPError=-2147217396</a><br />
<br />
Kelvin
</div>


Have look at this. Look like you can set this in Excel

https://msdn.microsoft.com/en-us/library/office/aa224907%28v=office.11%29.aspx?f=255&MSPPError=-2147217396 [https://msdn.microsoft.com/en-us/library/office/aa224907%28v=office.11%29.aspx?f=255&MSPPError=-2147217396]

Kelvin

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a sql query that takes 2 minutes to run. It runs fine but when I use it in VBA it gives me a query timeout error. Is there a setting that I need to change or include some code in vba.<br />
<br />
Thanks
</div>
</div>


Hi,

I have a sql query that takes 2 minutes to run. It runs fine but when I use it in VBA it gives me a query timeout error. Is there a setting that I need to change or include some code in vba.

Thanks

Query timeout

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.