|
PowerBuilder 10.5 provides native access to Adaptive Server Enterprise and Oracle using ADO.NET. You can connect to a database using the ADO.NET data providers and perform operations using native syntax. You can create a new connection or share an existing connection object for transaction management.
PowerBuilder now supports the following ADO.NET namespaces and 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
|
Support is provided in the PBADO105.DLL file and the Sybase.PowerBuilder.Db.dll and Sybase.PowerBuilder.DbExt.dll .NET assemblies. The ADO.NET drivers distributed with PowerBuilder are built with a specific version of the ADO.NET assemblies provided by Sybase and Oracle. You need to deploy Sybase.PowerBuilder.DbExt.dll with your application if you are using Oracle 10g or Adaptive Server 15 or later.
For more information
For more information, see the chapter about ADO.NET in Connecting to Your Database.
|
