---
title: "ExecuteOptions and FetchOptions Properties Example (VBScript) | Microsoft Docs"
ms.prod: sql
ms.prod_service: connectivity
ms.technology: connectivity
ms.custom: ""
ms.date: "01/19/2017"
ms.reviewer: ""
ms.topic: conceptual
dev_langs:
- "VB"
helpviewer_keywords:
- "FetchOptions property [ADO], VBScript example"
- "ExecuteOptions property [ADO]"
ms.assetid: 753a4a3d-0fba-40b8-86e7-50b34182ca69
author: MightyPen
ms.author: genemi
---
# ExecuteOptions and FetchOptions Properties Example (VBScript)
> [!IMPORTANT]
> Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and [Windows Server 2012 Compatibility Cookbook](https://www.microsoft.com/download/details.aspx?id=27416) for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to [WCF Data Service](https://go.microsoft.com/fwlink/?LinkId=199565).
The following code shows how to set the [ExecuteOptions](../../../ado/reference/rds-api/executeoptions-property-rds.md) and [FetchOptions](../../../ado/reference/rds-api/fetchoptions-property-rds.md) properties at design time. If left unset, **ExecuteOptions** defaults to **adcExecSync**. This setting indicates that when the **RDS.Refresh** method is called, it will be executed on the current calling thread-that is, synchronously. Cut and paste the following code to Notepad or another text editor and save it as **ExecuteOptionsDesignVBS.asp**.
```
<%@ Language=VBScript %>
Design-time ExecuteOptions and FetchOptions Properties Example
Design-time ExecuteOptions and FetchOptions Properties Example
First Name
Last Name
```
The following example shows how to set the **ExecuteOptions** and **FetchOptions** properties at run time in VBScript code. See the [Refresh](../../../ado/reference/rds-api/refresh-method-rds.md) method for a working example of these properties. Cut and paste the following code to Notepad or another text editor and save it as **ExecuteOptionsRuntimeVBS.asp**.
```
<%@ Language=VBScript %>
Run-time ExecuteOptions and FetchOptions Properties Example
Run-time ExecuteOptions and FetchOptions Properties Example
First Name
Last Name
```
## See Also
[ExecuteOptions Property (RDS)](../../../ado/reference/rds-api/executeoptions-property-rds.md)
[FetchOptions Property (RDS)](../../../ado/reference/rds-api/fetchoptions-property-rds.md)