Used to specify a provider from the list of supported providers.
property Provider: TMSProvider;
Use the Provider property to specify a provider from the list of supported providers. The default value of this property is prAuto. In this case a provider of the most recent version is used. Some features in SQL Server require the SQL Native Client (prNativeClient) provider to be used. If chosen provider is not installed, an exception is raised. The prCompact value should be set for working with SQL Server Compact Edition.