< Back
Set-OdbcDriver
Post
NAME Set-OdbcDriver
SYNOPSIS
Configures the properties for installed ODBC drivers.
SYNTAX
Set-OdbcDriver [-CimSession <CimSession[]>] [-PassThru] [-RemovePropertyValue <String[]>] [-SetPropertyValue <String[]>] [-ThrottleLimit <Int32>]
[-Confirm] [-WhatIf] [<CommonParameters>]
Set-OdbcDriver [-Name] <String> [-CimSession <CimSession[]>] [-PassThru] [-Platform {32-bit | 64-bit | All}] [-RemovePropertyValue <String[]>]
[-SetPropertyValue <String[]>] [-ThrottleLimit <Int32>] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Set-OdbcDriver cmdlet configures the properties for installed Open Database Connectivity (ODBC) drivers. Specify properties to add or modify by
using the SetPropertyValue parameter. Specify properties to remove by using the RemovePropertyValue parameter.
Use the driver installation program to install and uninstall a driver. You cannot install or uninstall a driver by using Windows PowerShell???? cmdlets.
For more information about ODBC and drivers, see Microsoft Open Database Connectivity (ODBC) (http://msdn.microsoft.com/en-us/library/ms710252.aspx) and
Drivers (http://msdn.microsoft.com/en-us/library/ms715383.aspx) on the Microsoft Developer Network.
PARAMETERS
-Name <String>
Specifies the name of a driver. You can use wildcard characters to specify more than one driver. This cmdlet modifies one or more ODBC drivers that
this parameter specifies.
Required? true
Position? 1
Default value none
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Platform [<String>]
Specifies the platform architecture. This cmdlet modifies an ODBC driver that belongs to the architecture that this parameter specifies. The
acceptable values for this parameter are:
-- 32-bit
-- 64-bit
-- All
The default value is 32-bit on a 32-bit process. The default value is 64-bit on a 64-bit process. If you run this cmdlet in a remote CIM session,
this parameter refers to the platform architecture on the remote computer.
Required? false
Position? named
Default value none
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-SetPropertyValue [<String[]>]
Specifies an array of property values. This cmdlet modifies or adds the values that this parameter specifies on an ODBC driver. Specify an array of
strings in the form <key>=<value>.
Required? false
Position? named
Default value none
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-RemovePropertyValue [<String[]>]
Specifies an array of property values to remove. This cmdlet removes the property values that this parameter specifies from the ODBC driver. Specify
an array of keys to be removed.
Required? false
Position? named
Default value none
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-PassThru [<SwitchParameter>]
Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
-CimSession [<CimSession[]>]
Runs the cmdlet in a remote session or on a remote computer. Enter a computer name or a session object, such as the output of a New-CimSession or
Get-CimSession cmdlet. The default is the current session on the local computer.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
-ThrottleLimit [<Int32>]
Specifies the maximum number of concurrent operations that can be established to run the cmdlet. If this parameter is omitted or a value of 0 is
entered, then Windows PowerShell???? calculates an optimum throttle limit for the cmdlet based on the number of CIM cmdlets that are running on the
computer. The throttle limit applies only to the current cmdlet, not to the session or to the computer.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value false
Accept pipeline input? false
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value false
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Microsoft.Management.Infrastructure.CimInstance#MSFT_OdbcDriver[]
Example 1: Assign a value for a 32-bit driver by using a name
PS C:\\> Set-OdbcDriver -Name "SQL Server Native Client 10.0" -Platform "32-bit" -SetPropertyValue "CPTimeout=60"
This command assigns the key CPTimeout a value of 60 for the 32-bit driver named SQL Server Native Client 10.0.
Example 2: Remove a property for any driver that starts with a string for the native platform
PS C:\\> Set-OdbcDriver -Name "SQL Server*" -RemovePropertyValue "aaa"
This command removes the property named aaa for all drivers that have a name that starts with SQL Server under the native platform.
Example 3: Change and remove properties for a driver
PS C:\\> Set-OdbcDriver -Name "SQL Server Native Client 10.0" -Platform "All" -RemovePropertyValue @("aaa1", "aaa2") -SetPropertyValue @("aaa3=bbb3",
"aaa4=bbb4")
This command operates on any driver named SQL Server Native Client 10.0 under both 32-bit and 64-bit architectures. The command removes the properties
aaa1 and aaa2. It also sets the property aaa3 to bbb3 and the property aaa4 to bbb4.
Example 4: Assign a value for a 32-bit driver by using a name and store the result
PS C:\\> $Driver = Set-OdbcDriver -Name "SQL Server Native Client 10.0" -Platform "32-bit" -SetPropertyValue "aaa=bbb" -PassThru
This command assigns the key aaa a value of bbb for the 32-bit driver named SQL Server Native Client 10.0, and then stores the driver object in the
$Driver variable.
Example 5: Change and remove properties for a driver by using the pipeline operator
PS C:\\> Get-OdbcDriver "SQL Server Native Client 10.0" -Platform "All" | Set-OdbcDriver -RemovePropertyValue @("aaa1", "aaa2") -SetPropertyValue
@("aaa3=bbb3", "aaa4=bbb4")
This command operates on any driver named SQL Server Native Client 10.0 under both 32-bit and 64-bit architectures. This command removes the properties
aaa1 and aaa2. It also sets the property aaa3 to bbb3 and the property aaa4 to bbb4.
Example 6: Change and remove properties for a driver by using a variable
PS C:\\> $DriverArray = Get-OdbcDriver "SQL Server Native Client 10.0" -Platform "All"
PS C:\\> Set-OdbcDriver -InputObject $DriverArray -RemovePropertyValue @("aaa1", "aaa2") -SetPropertyValue @("aaa3=bbb3", "aaa4=bbb4")
The first command uses the Get-OdbcDriver cmdlet to get any driver named SQL Server Native Client 10.0 under both 32-bit and 64-bit architectures, and
then stores them in the $DriverArray variable.
The second command removes the properties aaa1 and aaa2. It also sets the property aaa3 to bbb3 and the property aaa4 to bbb4.
RELATED LINKS
Get-OdbcDriver
SYNOPSIS
Configures the properties for installed ODBC drivers.
SYNTAX
Set-OdbcDriver [-CimSession <CimSession[]>] [-PassThru] [-RemovePropertyValue <String[]>] [-SetPropertyValue <String[]>] [-ThrottleLimit <Int32>]
[-Confirm] [-WhatIf] [<CommonParameters>]
Set-OdbcDriver [-Name] <String> [-CimSession <CimSession[]>] [-PassThru] [-Platform {32-bit | 64-bit | All}] [-RemovePropertyValue <String[]>]
[-SetPropertyValue <String[]>] [-ThrottleLimit <Int32>] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Set-OdbcDriver cmdlet configures the properties for installed Open Database Connectivity (ODBC) drivers. Specify properties to add or modify by
using the SetPropertyValue parameter. Specify properties to remove by using the RemovePropertyValue parameter.
Use the driver installation program to install and uninstall a driver. You cannot install or uninstall a driver by using Windows PowerShell???? cmdlets.
For more information about ODBC and drivers, see Microsoft Open Database Connectivity (ODBC) (http://msdn.microsoft.com/en-us/library/ms710252.aspx) and
Drivers (http://msdn.microsoft.com/en-us/library/ms715383.aspx) on the Microsoft Developer Network.
PARAMETERS
-Name <String>
Specifies the name of a driver. You can use wildcard characters to specify more than one driver. This cmdlet modifies one or more ODBC drivers that
this parameter specifies.
Required? true
Position? 1
Default value none
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Platform [<String>]
Specifies the platform architecture. This cmdlet modifies an ODBC driver that belongs to the architecture that this parameter specifies. The
acceptable values for this parameter are:
-- 32-bit
-- 64-bit
-- All
The default value is 32-bit on a 32-bit process. The default value is 64-bit on a 64-bit process. If you run this cmdlet in a remote CIM session,
this parameter refers to the platform architecture on the remote computer.
Required? false
Position? named
Default value none
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-SetPropertyValue [<String[]>]
Specifies an array of property values. This cmdlet modifies or adds the values that this parameter specifies on an ODBC driver. Specify an array of
strings in the form <key>=<value>.
Required? false
Position? named
Default value none
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-RemovePropertyValue [<String[]>]
Specifies an array of property values to remove. This cmdlet removes the property values that this parameter specifies from the ODBC driver. Specify
an array of keys to be removed.
Required? false
Position? named
Default value none
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-PassThru [<SwitchParameter>]
Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
-CimSession [<CimSession[]>]
Runs the cmdlet in a remote session or on a remote computer. Enter a computer name or a session object, such as the output of a New-CimSession or
Get-CimSession cmdlet. The default is the current session on the local computer.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
-ThrottleLimit [<Int32>]
Specifies the maximum number of concurrent operations that can be established to run the cmdlet. If this parameter is omitted or a value of 0 is
entered, then Windows PowerShell???? calculates an optimum throttle limit for the cmdlet based on the number of CIM cmdlets that are running on the
computer. The throttle limit applies only to the current cmdlet, not to the session or to the computer.
Required? false
Position? named
Default value none
Accept pipeline input? false
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value false
Accept pipeline input? false
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value false
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Microsoft.Management.Infrastructure.CimInstance#MSFT_OdbcDriver[]
Example 1: Assign a value for a 32-bit driver by using a name
PS C:\\> Set-OdbcDriver -Name "SQL Server Native Client 10.0" -Platform "32-bit" -SetPropertyValue "CPTimeout=60"
This command assigns the key CPTimeout a value of 60 for the 32-bit driver named SQL Server Native Client 10.0.
Example 2: Remove a property for any driver that starts with a string for the native platform
PS C:\\> Set-OdbcDriver -Name "SQL Server*" -RemovePropertyValue "aaa"
This command removes the property named aaa for all drivers that have a name that starts with SQL Server under the native platform.
Example 3: Change and remove properties for a driver
PS C:\\> Set-OdbcDriver -Name "SQL Server Native Client 10.0" -Platform "All" -RemovePropertyValue @("aaa1", "aaa2") -SetPropertyValue @("aaa3=bbb3",
"aaa4=bbb4")
This command operates on any driver named SQL Server Native Client 10.0 under both 32-bit and 64-bit architectures. The command removes the properties
aaa1 and aaa2. It also sets the property aaa3 to bbb3 and the property aaa4 to bbb4.
Example 4: Assign a value for a 32-bit driver by using a name and store the result
PS C:\\> $Driver = Set-OdbcDriver -Name "SQL Server Native Client 10.0" -Platform "32-bit" -SetPropertyValue "aaa=bbb" -PassThru
This command assigns the key aaa a value of bbb for the 32-bit driver named SQL Server Native Client 10.0, and then stores the driver object in the
$Driver variable.
Example 5: Change and remove properties for a driver by using the pipeline operator
PS C:\\> Get-OdbcDriver "SQL Server Native Client 10.0" -Platform "All" | Set-OdbcDriver -RemovePropertyValue @("aaa1", "aaa2") -SetPropertyValue
@("aaa3=bbb3", "aaa4=bbb4")
This command operates on any driver named SQL Server Native Client 10.0 under both 32-bit and 64-bit architectures. This command removes the properties
aaa1 and aaa2. It also sets the property aaa3 to bbb3 and the property aaa4 to bbb4.
Example 6: Change and remove properties for a driver by using a variable
PS C:\\> $DriverArray = Get-OdbcDriver "SQL Server Native Client 10.0" -Platform "All"
PS C:\\> Set-OdbcDriver -InputObject $DriverArray -RemovePropertyValue @("aaa1", "aaa2") -SetPropertyValue @("aaa3=bbb3", "aaa4=bbb4")
The first command uses the Get-OdbcDriver cmdlet to get any driver named SQL Server Native Client 10.0 under both 32-bit and 64-bit architectures, and
then stores them in the $DriverArray variable.
The second command removes the properties aaa1 and aaa2. It also sets the property aaa3 to bbb3 and the property aaa4 to bbb4.
RELATED LINKS
Get-OdbcDriver