Using a native database interface

You perform several basic steps to use a native database interface to access a database.

About preparing to use the database

The first step in connecting to a database through a native database interface is to prepare to use the database. Preparing the database ensures that you will be able to access and use your data in PowerBuilder.

You must prepare the database outside PowerBuilder before you start the product, then define the database interface and connect to it. The requirements differ for each database -- but in general, preparing a database involves four basic steps.

To prepare to use your database with PowerBuilder:

  1. Make sure the required database server software is properly installed and configured at your site.

  2. If network software is required, make sure it is properly installed and configured at your site and on the client computer so that you can connect to the database server.

  3. Make sure the required database client software is properly installed and configured on the client computer. (Typically, the client computer is the one running PowerBuilder.)

    You must obtain the client software from your database vendor and make sure that the version you install supports all of the following:

    The operating system running on the client computer

    The version of the database that you want to access

    The version of PowerBuilder that you are running

  4. Verify that you can connect to the server and database you want to access outside PowerBuilder.

For specific instructions to use with your database, see "Preparing to use the database" in the chapter for your native database interface.

About installing native database interfaces

After you prepare to use the database, you must install the native database interface that accesses the database. See the instructions for each interface for more information.

About defining native database interfaces

Once you are ready to access the database, you start PowerBuilder and define the database interface. To define a database interface, you must create a database profile by completing the Database Profile Setup dialog box for that interface.

For general instructions, see About creating database profiles. For instructions about defining database interface parameters unique to a particular database, see "Preparing to use the database" in the chapter for your database interface.

For more information

The following chapters give general information about using each native database interface. For more detailed information:

  • Check to see if there is a technical document that describes how to connect to your database.

  • Ask your network or system administrator for assistance when installing and setting up the database server and client software at your site.