Preparing to use the OLE DB interface
Before you define the interface and connect to a data provider through
the OLE DB:
- Install and configure the database
server, network, and client software. - Install the OLE DB interface and the OLE DB data
provider that accesses your data source. - Install Microsoft’s Data Access Components
software on your machine. - If required, define the OLE DB data source.
Step 1: Install and configure the data server
You must install and configure the database server and install
the network software and client software.
To install and configure the database server,
network, and client software:
-
Make sure the appropriate database software
is installed and running on its server.You must obtain the database server software from your database
vendor. For installation instructions, see your database vendor’s
documentation. -
Make sure the required network software (such
as TCP/IP) is installed and running on your computer and
is properly configured so that you can connect to the data server
at your site. You must install the network communication driver
that supports the network protocol and operating system platform
you are using.For installation and configuration instructions,
see your network or data source administrator. -
If required, install the appropriate client software
on each client computer on which PowerBuilder is installed.
Client software requirements To determine client software requirements, see your database
vendor’s documentation. To access supported remote Informix
databases through the Informix data provider, you need Informix
Connect for Windows platforms, version 2.x, or the Informix Client
Software Development Kit for Windows platforms, version 2.x.
Step 2: Install the OLE DB interface and data provider
In the PowerBuilder Setup program, select the Custom install
and select the OLE DB provider that accesses your database. You
can install one or more of the OLE DB data providers shipped with PowerBuilder,
or you can install data providers from another vendor later.
Step 3: Install the Microsoft Data Access Components
software
The PowerBuilder OLE DB interface requires the functionality
of the Microsoft Data Access Components software (MDAC). The installation
of MDAC is not part of the PowerBuilder installation. You must perform
this installation separately by executing the file mdac_typ.exe found
in the Support directory.
OLE DB data providers installed with Microsoft Data
Access Components When you execute the mdac_typ file,
several Microsoft OLE DB data providers are automatically installed,
including the following:
- Microsoft
OLE DB Provider for ODBC (MSDASQL) - Microsoft OLE DB Provider for SQL Server (SQLOLEDB)
Step 4: Define the OLE DB data source
Once the OLE DB data provider is installed, you may have to
define the OLE DB data source the data provider will access. How
you define the data source depends on the OLE DB data provider you
are using and the vendor who provided it.
To define a data source for one of the OLE DB data providers
shipped with PowerBuilder, use the DataDirect OLE DB Administrator.
This utility is named PBadmin and can be found
in SybaseSharedDataDirect.
If you are connecting to an ODBC data provider (such as Microsoft’s
OLE DB Provider for ODBC), you must define the ODBC data source
as you would if you were using a direct ODBC connection. To define
an ODBC data source, use Microsoft’s ODBC Data Source Administrator.
This utility can be accessed through the Control Panel in Windows
or through the Database painter.