Set provider properties

Before you create a linked server, you need to set the provider properties for the PISQLClient provider. You only need to set the properties once because they apply to all linked servers using the PISQLClient provider.

1. Start SSMS and connect to the database engine.

2. In the Object Explorer pane, navigate to PI SQL Client OLEDB (Server Objects > Linked Servers > Providers > PISQLClient).

3. Right-click PISQLClient and click Properties.

   The Provider Options - PI SQL Client window opens.

4. Select the check box for each of the following provider options.

   Option	Description
   Dynamic parameter	Indicates that PI SQL Client OLEDB allows ? parameter marker syntax for parameterized queries. Allows SQL Server to execute parameterized queries against PI SQL Client OLEDB.
   Nested queries	Indicates that PI SQL Client OLEDB allows nested SELECT statements in the FROM clause.
   Allow inprocess	Allows PI SQL Client OLEDB to be instantiated as an in-process server. You can use PI SQL Client OLEDB in an out-of-process configuration. See Out-of-process configuration.
   Supports 'Like' operator	Indicates that PI SQL Client OLEDB supports queries using the LIKE keyword.

   

5. Click OK.