Preparing to use the ADO.NET interface

Before you define the interface and connect to a database using ADO.NET:

  1. Install and configure the database server, network, and client software.

  2. Install the ADO.NET interface.

  3. Install Microsoft's Data Access Components version 2.6 or higher software on your machine.

Step 1: Install and configure the data server

You must install and configure the database server and install the network software and client software.

To install and configure the database server, network, and client software:

  1. Make sure the appropriate database software is installed and running on its server.

    You must obtain the database server software from your database vendor. For installation instructions, see your database vendor's documentation.

  2. Make sure the required network software (such as TCP/IP) is installed and running on your computer and is properly configured so that you can connect to the data server at your site. You must install the network communication driver that supports the network protocol and operating system platform you are using.

    For installation and configuration instructions, see your network or data source administrator.

  3. If required, install the appropriate client software on each client computer on which PowerBuilder is installed.

Client software requirements

To determine client software requirements, see your database vendor's documentation.

Step 2: Install the ADO.NET interface

If you install PowerBuilder using the PowerBuilder Installer (an online setup program), the ADO.NET interface is automatically installed. If you install PowerBuilder using the downloaded installation package (an offline setup program), select the ADO .NET Database Driver from the list of components.

Step 3: Install the Microsoft Data Access Components software

The PowerBuilder ADO.NET interface requires the functionality of the Microsoft Data Access Components (MDAC) version 2.8 or higher software.

To check the version of MDAC on your computer, you can download and run the MDAC Component Checker utility from the MDAC Downloads page at http://msdn.microsoft.com/en-us/data/aa937730.aspx.

OLE DB data providers installed with MDAC

Several Microsoft OLE DB data providers are automatically installed with MDAC, including the providers for SQL Server (SQLOLEDB) and ODBC (MSDASQL).