How to find the information you need
When you work with PowerBuilder, you can connect to a database
in the development environment or in an application script.
This book describes how to connect to your database in the PowerBuilder development
environment.
For information about connecting to a database
in a PowerBuilder application script, see Application
Techniques.
Basic connection procedure
The following table gives an overview of the connection procedure
and indicates where you can find detailed information about each
step.
Step |
Action |
Details |
See |
---|---|---|---|
1 |
(Optional) Get an introduction to database connections |
If necessary, learn more about how PowerBuilder connects |
Chapter 1 (this chapter) |
2 |
Prepare to use the data source or database |
Outside PowerBuilder, install the required |
For ODBC data sources: Chapter 2, “Using the ODBC Interface” For JDBC data sources: Chapter 3, “Using the JDBC Interface” For OLE DB data sources: Chapter 4, “Using the OLE DB Interface” For ADO.NET data sources: Chapter 5, “Using the ADO.NET Interface” For native database interfaces: Chapter 6, “Using Native Database Interfaces” |
3 |
Install the ODBC driver, OLE DB data |
Install the driver, database provider, |
For a list of what is supported on your |
4 |
Define the data source (ODBC connections |
Create the required configuration for |
For ODBC data sources: Chapter 2, “Using the ODBC Interface” |
5 |
Define the database interface |
Create the database profile |
For ODBC data sources: Chapter 2, “Using the ODBC Interface” For JDBC data sources: Chapter 3, “Using the JDBC Interface” For OLE DB data sources: Chapter 4, “Using the OLE DB Interface” For ADO.NET data sources: Chapter 5, “Using the ADO.NET Interface” For native database interfaces: Chapter 6, “Using Native Database Interfaces” For PowerBuilder components: Chapter 15, “Making Database Connections |
6 |
Define the EAServer connection |
Create an EAServer profile |
Chapter 15, “Making Database Connections |
7 |
Connect to the data source or database |
Access the data in PowerBuilder |
|
8 |
(Optional) Set additional connection |
If necessary, set DBParm parameters and |
For procedures: Chapter 13, “Setting Additional Connection Parameters” For DBParm descriptions: For database preference descriptions: |
9 |
(Optional) Troubleshoot the data connection |
If necessary, use the trace tools to |