Components of an ADO.NET connection

When you access a database using ADO.NET in PowerBuilder, your connection goes through several layers before reaching the database. It is important to understand that each layer represents a separate component of the connection, and that components might come from different vendors.

The PowerBuilder ADO.NET interface consists of a driver (pbado125.dll) and a server (either Sybase.PowerBuilder.Db.dll or Sybase.PowerBuilder.DbExt.dll). The server has dependencies on a file called pbrth125.dll. These DLLs must be deployed with an application that connects to a database using ADO.NET. For Oracle 10g or Adaptive Server 15 or later, use Sybase.PowerBuilder.DbExt.dll. For earlier versions and other DBMSs, use Sybase.PowerBuilder.Db.dll.

The DataWindow .NET database interface for ADO.NET supports the ADO.NET data providers listed in Table 5-1.

**Table 5-1: Supported ADO.NET data providers**
Data Provider	Namespace
.NET Framework Data Provider for OLE DB	System.Data.OleDb
.NET Framework Data Provider for SQL Server	System.Data.SqlClient
Oracle Data Provider for .NET (ODP.NET)	Oracle.DataAccess.Client
Sybase ADO.NET Data Provider for Adaptive Server Enterprise (ASE)	Sybase.Data.AseClient

Additional .NET Framework data providers may be supported in future releases. Please see the release bulletin for the latest information.

Figure 5-1 shows the general components of an ADO.NET connection using the OLE DB .NET Framework data provider.

Figure 5-1: Components of an ADO.NET OLE DB connection

For an OLE DB ADO.NET connection, the development environment connects to the database via the P B A D O dot NET D L L, the Sybase dot PowerBuilder dot D B and D B ext D L Ls, the dot net framework data provider system dot data dot ole DB, and an ole d b data provider.

Figure 5-2 shows the general components of an ADO.NET connection using a native ADO.NET data provider.

Figure 5-2: Components of a native ADO.NET connection

The development environment connects to the database via the P B A D O dot NET D L L, the Sybase dot PowerBuilder dot D B and D B ext D L Ls, and the dot net framework data provider system dot data dot sequel client, oracle dot data access dot client, or sybase dot data doe a s e client.