Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Provider – PB Docs 126 – PowerBuilder Library

Provider – PB Docs 126

Provider database parameter

Description

Identifies the data provider you want to use to connect to
your data source.

note.png 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

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.

note.png 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
    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:

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:

Example 3

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:

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:

See Also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x