Provider
database parameter
Description
Identifies the data provider you want to use to connect to your
data source.
When to specify Provider
You must specify the Provider parameter before connecting to the
database.
Applies to
ADO.NET
OLE DB
SNC SQL Native Client for Microsoft SQL Server
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
Syntax
|
1 |
Provider='provider_name' |
Default value
None
Usage
Select a data provider from the list of installed data providers
displayed in the Provider drop-down list. For example, if you are using
Microsoft’s OLE DB Provider for ODBC, select MSDASQL as the Provider
value. If you are using Microsoft’s OLE DB Provider for SQL Server,
select SQLOLEDB as the Provider value.
For more information, see the documentation provided by your OLE
DB or ADO.NET data provider.
SNC SQL Native Client driver
The Provider DBParm parameter for the Microsoft SQL Native
Client (SNC) interface allows you to select the SNC version that you
want to use for a database connection. You can set this parameter in
script to SQLNCLI (for the SNC 9.0 driver that connects to SQL Server
2005) or to SQLNCLI10 (for the SNC 10.0 driver that connects to SQL
Server 2008) or to SNC 11 (for the SNC 11 driver that connects to SQL
Server 2012 or later). Otherwise, you can select one of these
providers on the Connection tab of the Database Profile Setup dialog
box for the SNC interface.
If you do not set or select a provider, the default selection is
SQLNCLI (SNC 9.0 for SQL Server 2005). This allows existing SNC
interface users to be able to upgrade to the current release of
PowerBuilder without any modifications. If PowerBuilder fails to connect
with the SQLNCLI provider, it will attempt to connect to SQLNCLI10
provider. However, if you explicitly set the provider and the connection
fails, PowerBuilder displays an error message.
Examples
Example 1
To use the Microsoft OLE DB Provider for ODBC to connect to the PB
Demo DB:
-
Database profile
Select MSDASQL from the Provider drop-down list on the
Connection page in the Database Profile Setup dialog box for OLE
DB. -
Application
Type the following in code:
1SQLCA.DBParm="Provider='MSDASQL'"
Example 2
To use the Microsoft OLE DB Provider for Oracle to connect to an
Oracle 8 database:
-
Database profile
Select MSDAORA from the Provider drop-down list on the
Connection page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="Provider='MSDAORA'"
Example 3
To use the SAP Sybase Oracle8 ADO Provider to connect to an Oracle
8 database:
-
Database profile
Select Sybase.Oracle8ADOProvider from the Provider drop-down
list on the Connection page in the Database Profile Setup dialog box
for ADO.NET. -
Application
Type the following in code:
1SQLCA.DBParm="PROVIDER='Sybase.Oracle8ADOProvider'"
Example 4
To use the Microsoft SNC software to connect to a Microsoft SQL
Server 2016 database:
-
Database profile
Select SQLNCLI11 from the Provider drop-down list on the
Connection page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="Provider='SQLNCLI11'"
See also