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. Version 2.8 is distributed with Windows XP Service Pack 2 and Windows Server 2003.

To check the version of MDAC on a computer, users can download and run the MDAC Component Checker utility from the MDAC Downloads page.

On the Windows Vista and Windows 7 operating systems, the Windows Data Access Components (DAC) version 6.0 replaces MDAC, and implements the functionality requirements of the PowerBuilder OLE DB interface.

NoteOLE DB data providers Several Microsoft OLE DB data providers are automatically installed with MDAC and DAC, including the providers for SQL Server (SQLOLEDB) and ODBC (MSDASQL).

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:

Table 36-10: PowerBuilder OLE DB interface files

Name

Description

pbole125.dll

PowerBuilder OLE DB interface

pbodb125.ini

PowerBuilder ODBC initialization file

Installed path \Program Files\Sybase\Shared\PowerBuilder

Deployment path Same directory as the application, in a directory on the system path, or in the App Path registry key.

Registry entries See “App Path registry key”.

Notes The INI and DLL files must be in the same directory. If you have modified the pbodb125 initialization file, make sure you deploy the modified version.