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.
Controls
-
ADO.NET
-
OLE DB
-
SNC SQL Native Client for Microsoft SQL Server
Syntax
|
1 |
Provider='<span>provider_name</span>' |
Default
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 connect to SQL Server 2005) or to SQLNCLI10 (for the SNC
10.0 driver that connects to SQL Server 2008). 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 migrate 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
EAS Demo DB:
-
Database
profileSelect 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.DbParameter="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.DbParameter="Provider='MSDAORA'"
Example 3
To use the Sybase Oracle8 ADO Provider to connect to an Oracle 8
database:
-
Database
profileSelect 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.DbParameter="PROVIDER='Sybase.Oracle8ADOProvider'"
Example 4
To use the Microsoft SNC Provider to connect to a Microsoft SQL Server 2008 database:
-
Database profile
Select SQLNCLI10 from
the Provider drop-down list on the Connection page in the Database
Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DbParameter="Provider='SQLNCLI10'"