SQL Provider

  • Article

Passes SQL and ADO commands to an OLE DB provider on a database server. Used by Microsoft.Provisioning.Monitoring .Net Namespace.

Implementation

Program Files\Microsoft Provisioning\Providers\MPFSqlProv.dll

Properties

Name SQL Provider

Version

1

Provider Source

Provisioning.SQLProvider.1

Errors

The following table lists the errors returned by this Providers [HMC SDK].

HRESULT Description

(DWORD)0xC0001800L

The SQL Provider encountered a connection error while executing a command.%r%rConnection String="%1".%r%rServer reported errors:%r%2.

(DWORD)0xC0001801L

The SQL Provider cannot create more than %1 connections with connection string="%2".

(DWORD)0xC0001802L

The node "%1" has an incorrect value: "%2".

Remarks

Two Windows registry values allow customization of SQL Provider. These values are located in \HKEY_LOCAL_MACHINE\Software\Microsoft\Provisioning\Providers\SQL Provider.

MaxConnCount

Maximum number of simultaneous TCP sessions per SQL database server. The default value is 0xFFFFFFFF (unlimited).

When SQL Provider receives a call, the input XML establishes a connection (connect node) to the SQL database. MaxConnCount defines the number of simultaneous connections per connect string. For more information on the connect node, see the documentation.

If the processor is overloaded, the connection times out.

MaxRows

Maximum number of rows that can be returned for an ADO recordset. The default value is 4,096.

Public Methods

Procedure Description

SQL Provider:: 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.

Applies To

  • Hosted Messaging and Collaboration version 4.5

  • Hosted Messaging and Collaboration version 4.0

  • Hosted Messaging and Collaboration version 3.5

  • Hosted Messaging and Collaboration version 3.0

  • Windows-based Hosting version 4.5

  • Windows-based Hosting version 4.0

  • Windows-based Hosting version 3.5

  • Windows-based Hosting for Applications version 1.0