OLE DB database providers
If your application uses OLE DB to access data, you must install
Microsoft’s Data Access Components software on each user’s computer if
it is not installed already.
The PowerBuilder OLE DB interface requires the functionality of
the Microsoft Data Access Components (MDAC) version 2.8 or later
software.
To check the version of MDAC on a computer, users can download and
run the MDAC Component Checker utility from the MDAC Downloads page at
https://msdn.microsoft.com/en-us/data/aa937730.aspx.
On the Windows 10 operating systems, the Windows Data Access
Components (DAC) version 6.0 replaces MDAC, and implements the
functionality requirements of the PowerBuilder OLE DB interface.
OLE DB data providers
Several Microsoft OLE DB data providers are automatically
installed with MDAC and DAC, including the OLE DB Provider for SQL
Server (SQLOLEDB) and OLE DB Provider for ODBC (MSDASQL).
OLE DB Provider for SQL Server (SQLOLEDB) is not maintained any
more and it is not recommended to use it for new development work.
Instead, use the new OLE DB Driver for SQL Server (MSOLEDBSQL) which
will be updated with the most recent server features. The new OLE DB
Driver for SQL Server (MSOLEDBSQL) must be used with the “MSOLEDBSQL
SQL Server” interface (instead of the “OLE Microsoft OLE DB”
interface) installed with PowerBuilder.
PowerBuilder OLE DB interface
files
The PowerBuilder OLE DB interface file is required if your
application uses OLE DB. The ODBC initialization file is required if you
have used it to customize OLE DB settings:
|
Name |
Description |
|---|---|
|
pbole.dll |
PowerBuilder OLE DB interface |
|
pbodb.ini |
PowerBuilder ODBC initialization |
Installed path
%systemdrive%Program Files
(x86)AppeonCommonPowerBuilderRuntime [version]
Deployment path
Same directory as the application, in a directory on the system
path, or in the App Path registry
key.
Registry entries
Notes
The INI and DLL files must be in the same directory. If you have
modified the pbodb.ini file, make sure you deploy the modified
version.