SQL Provider

The SQL Provider namespace allows service providers and resellers to pass Structured Query Language (SQL) and ActiveX Data Objects (ADO) commands to an OLE DB provider on a database server.

With the SQL Provider namespace, you use a single procedure, ExecSQL or Execute SQL, to pass parameters to the SQL command on a database server.

The SQL Provider namespace implements the following procedures.

Procedure	Description
ExecSQL	Passes SQL and ADO commands to an OLE DB provider on a database server. Binds input and output parameters to the SQL command and returns an XML response.

Note

Two Windows registry values allow for customization of the SQL provider. These values are located in HKEY_LOCAL_MACHINE\Software\Microsoft\Provisioning\Providers\SQL Provider. Customization options include specifying the maximum number of simultaneous TCP sessions per SQL database server and the maximum number of rows that can be returned for an ActiveX Data Objects (ADO) recordset.

Caution

Incorrectly editing the registry may severely damage your system. Before making changes to the registry, you should back up any valued data on the computer.

The Microsoft Provisioning Framework Software Development Kit (SDK) contains additional resources to help you implement the SQL Provider namespace. For more information on the SDK and how to use it, see Microsoft Provisioning Framework SDK.