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 higher 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 operating system, the Windows Data Access Components (DAC) version 6.0 includes some changes to work with Vista but is otherwise functionally equivalent to MDAC 2.8.

NoteOLE DB data providers installed with MDAC Several Microsoft OLE DB data providers are automatically installed with MDAC, 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 41-10: PowerBuilder OLE DB interface files

Name

Description

pbole110.dll

PowerBuilder OLE DB interface

pbodb110.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 pbodb110 initialization file, make sure you deploy the modified version.