You perform several basic steps to use a native database interface to access a 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:
Make sure the required database server software is properly installed and configured at your site.
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.
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
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.
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.
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.
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. Any updated information about connectivity issues is available from the Sybase Support and Downloads Web site.
Ask your network or system administrator for assistance when installing and setting up the database server and client software at your site.
