To ensure your application connects properly with the database using ADO.NET, you must package and distribute the .NET Desktop Runtime and the PowerBuilder runtime files along with your application.
-
.NET Desktop Runtime 8.0
.NET Desktop Runtime 8.0 must be installed to the client to support the ADO.NET database connection.
You will have to manually package and distribute .NET Desktop Runtime. (Make sure the platform (32-bit or 64-bit) of .NET Desktop Runtime matches that of the application executable file.)
-
PowerBuilder runtime files
Besides .NET Desktop Runtime, you will also need to package and distribute the PowerBuilder runtime files, either in an automatic or manual way.
To package the files automatically, select the database type in the Runtime Packager so that the packager can automatically package the files according to the database type.
To package the files manually, go to the PowerBuilder Runtime location and get the files according to the following table.
Database type
Dependency files
ORACLE
Appeon.DB.Base.dll
Appeon.DB.Base.deps.json
Appeon.DB.Proxy.dll
Appeon.DB.Proxy.runtimeconfig.json
Appeon.DB.Proxy.deps.json
Appeon.DB.Oracle.dll
Appeon.DB.Oracle.deps.json
Microsoft.Win32.SystemEvents.dll
Oracle.ManagedDataAccess.dll
pbDBDriver.dll
System.Configuration.ConfigurationManager.dll
System.Diagnostics.PerformanceCounter.dll
System.DirectoryServices.dll
System.DirectoryServices.Protocols.dll
System.Drawing.Common.dll
System.Security.Cryptography.ProtectedData.dll
System.Security.Permissions.dll
System.Windows.Extensions.dll
PostgreSQL
Appeon.DB.Base.dll
Appeon.DB.Base.deps.json
Appeon.DB.PostgreSql.dll
Appeon.DB.Proxy.dll
Appeon.DB.Proxy.runtimeconfig.json
Appeon.DB.Proxy.deps.json
Appeon.DB.Sharing.dll
Appeon.DB.Sharing.deps.json
ljwhost.dll
Microsoft.Extensions.Logging.Abstractions.dll
Npgsql.dll
pbDBDriver.dll
SQL Server
Appeon.DB.Base.dll
Appeon.DB.Base.deps.json
Appeon.DB.Proxy.dll
Appeon.DB.Proxy.runtimeconfig.json
Appeon.DB.Proxy.deps.json
Appeon.DB.SQLServer.dll
Appeon.DB.SQLServer.deps.json
Azure.Core.dll
Azure.Identity.dll
Microsoft.Data.SqlClient.dll
Microsoft.Data.SqlClient.SNI.dll
Microsoft.Identity.Client.dll
Microsoft.SqlServer.Server.dll
Microsoft.Bcl.AsyncInterfaces.dll
Microsoft.Identity.Client.Extensions.Msal.dll
Microsoft.IdentityModel.Abstractions.dll
Microsoft.IdentityModel.JsonWebTokens.dll
Microsoft.IdentityModel.Logging.dll
Microsoft.IdentityModel.Protocols.dll
Microsoft.IdentityModel.Protocols.OpenIdConnect.dll
Microsoft.IdentityModel.Tokens.dll
Microsoft.Win32.SystemEvents.dll
pbDBDriver.dll
System.Configuration.ConfigurationManager.dll
System.Security.Permissions.dll
System.Drawing.Common.dll
System.IdentityModel.Tokens.Jwt.dll
System.Memory.Data.dll
System.Runtime.Caching.dll
System.Security.Cryptography.ProtectedData.dll
System.Windows.Extensions.dll
ODBC
Appeon.DB.Base.dll
Appeon.DB.Base.deps.json
Appeon.DB.Odbc.dll
Appeon.DB.Odbc.deps.json
Appeon.DB.Proxy.dll
Appeon.DB.Proxy.runtimeconfig.json
Appeon.DB.Proxy.deps.json
pbDBDriver.dll
System.Data.Odbc.dll