Preparing to use the ADO.NET interface
ADO.NET is a set of technologies that provide native access to data
in the Microsoft .NET Framework.
To connect to a database using the PowerBuilder ADO.NET database
interface, you must use a .NET Core driver.
Currently, you can use the PowerBuilder ADO.NET database interface
to connect to the data source of SQL Server, Oracle, and ODBC.
Before you define the interface and connect to a database using
ADO.NET:
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:
-
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. -
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. -
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 .NET Core
driver
To connect to a database using the PowerBuilder ADO.NET database
interface, you must use a .NET Core driver.
-
For SQL Server and ODBC, the corresponding .NET Core drivers
have been automatically included and installed with
PowerBuilder. -
For Oracle, the corresponding .NET Core driver is not included
in PowerBuilder. You can manually download Oracle.ManagedDataAccess.Core.x.xx.xxxx from
the NuGet website or have PowerBuilder automatically download the
driver from the NuGet website.When you select Oracle from the
Provider list in the Database Profile Setup — ADO.NET DB dialog
box, you will be prompted to have PowerBuilder automatically download
and install the driver from www.nuget.org
or manually download the driver from NuGet and then specify the
location of driver on the development PC.The driver downloaded from the NuGet website will be stored to
%USERPROFILE%.netdbdrives; it will be automatically loaded when the
database connection is created in the PowerBuilder IDE or when the
file is packaged by the PowerBuilder Runtime Packager.