Identifies the data provider you want to use to connect to your data source.
ADO.NET
OLE DB
SNC SQL Native Client for Microsoft SQL Server
Provider='provider_name'
None
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.
To use the Microsoft OLE DB Provider for ODBC to connect to the EAS 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:
SQLCA.DBParm="Provider='MSDASQL'"
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:
SQLCA.DBParm="Provider='MSDAORA'"
To use the 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:
SQLCA.DBParm="PROVIDER='Sybase.Oracle8ADOProvider'"
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:
SQLCA.DBParm="Provider='SQLNCLI10'"
