In the Power builder, there is a menu item "Database Profile", which is considered to be the "set up data Base" feature, a set of parameters named in the Power Builder that allows you to define a connection-specific database. This can be used by specific database applications, it can be said that if the use of the database as a data source, the development of a suitable data profile is an essential prerequisite, this and VF and access to the processing mechanism is very similar.
In the Power builder9.0, click on the "Tools" drop-down menu in the General menu and select the "Database Profile" to open the definition interface of the databases, where we can select and define the links to the database. Select the database you want to connect to. Then click on the Connect button to go.
Here is a list of the types of database connections supported in power Builder:
To connect to a specified DBMS (database management system, such as Db2,oracle,informix, etc.), you need to install two components:
The first component is the database interface provided by PowerBuilder, usually the form of a dynamic-link library, whose name is usually PBXXX110.DLL, where xxx is a three-character description of the DBMS, followed by a 110 representative version, For example, PBO90110.DLL is a ORACLE9.0 database interface
The second component is the interface file provided by the DBMS vendor, usually in the form of a dynamic link library, and the top-level is the network support component of the database, which is determined by the type of network used by the DBMS server.
Powerbuilder<-->powerbuilder Database Interface <-->dbms Vendor-supplied interface <-->dbms
Identification of Informix9======================>dbms IN9
Identification of Jdbc==========================>dbms JDB
Identification of ODBC interface =======================>dbms ODB
OLE Db=========================>dbms's identity OLE
ORACLE8. Identification of X and ORACLE 8i============>dbms O84
Identification of Oracle9i=======================>dbms O90
Sybase Directconnect==============>dbms's identity DIR
Identification SYC for SYBASE adaptive SERVER Enterprise=====>dbms
The identity of the SYBASE Adaptive SERVER ENTERPRISE for Easerver=>dbms Syj
A detailed understanding of the interface of the database is very necessary, only in this way, in the release of the program, will not be due to the lack of an interface file caused the database connection failed.