ADO.NET database interface
The PowerBuilder ADO.NET interface supports the OLE DB, Microsoft
SQL Server .NET, Oracle ODP.NET, and SAP ASE data providers. If you use
ADO.NET, you must deploy pbado.dll, pbrth.dll,
sybase.PowerBuilder.Db.dll, sybase.PowerBuilder.DbExt.dll, and, for OLE
DB, the OLE DB data provider.
The files pbado.dll and pbrth.dll are standard DLL files, and you
can deploy them in the same way as other PowerBuilder DLLs. However,
sybase.PowerBuilder.Db.dll and sybase.PowerBuilder.DbExt.dll are .NET
assemblies. You can use one of three techniques to deploy the
files:
-
Deploy sybase.PowerBuilder.Db.dll and
sybase.PowerBuilder.DbExt.dll in the same directory as the
executable file that calls the ADO.NET driver. -
Use a .NET application configuration file to assign the path
of sybase.PowerBuilder.Db.dll and sybase.PowerBuilder.DbExt.dll. The
file contains configuration settings that the common language
runtime (CLR) reads as well as settings that the application reads.
For an executable file, the configuration file has the same name as
the executable file with the extension .config. The pb190.exe.config
file in your PowerBuilder 2019 R3 directory is an example.For more information about configuration files, see the
Microsoft Visual Studio SDK documentation. -
Add the sybase.PowerBuilder.Db.dll and
sybase.PowerBuilder.DbExt.dll assemblies to the Global Assembly
Cache (GAC). For more information about the GAC, see the section on
the Global Assembly Cache in the Microsoft Visual Studio SDK
documentation. If you use the Runtime Packager, the assemblies are
installed in the GAC.