How PB connects Oracle databases

ODBC or PowerBuilder's own DB profile or private interface to the database, but there are still many users who are unable to connect to the database by this method, which may be the cause of PowerBuilder itself, For example, the option to install PowerBuilder, the version of ODBC, or the problem with software that installs clients such as Oracle, Sybase, Informix, SQL Server, and so on, starts with the most basic ODBC configuration, Teach you step-by-step how to connect to a database.

Configuration of ODBC data sources

Enter the control Panel, open the ODBC data source (32-bit), as shown in Figure 1, click the "ADD" button to enter the ODBC data source configuration panel, as shown in Figure 2:

Select Oracle ODBC Driver to focus on the current version number "8.00.0400", and if you have Oracle7 installed in your operating system, the corresponding version number will be different. Note: Oracle8.0.4 cannot be installed on the WINDOWS98 operating system (only Oracle7.2.3 can be installed), Oracle8.0.5 has not been tried. As a result, some users will not be able to properly configure the ODBC data source on the WINDOWS98 system because the WINDOWS98 itself has an ODBC data source that is already higher than the version of the Oracle7 data source, no matter how you configure ODBC, The system always prompts you to install a later version of Oracle, you will not be able to configure ODBC, there is a solution is to use the PB7 on the second CD of ODBC installation program to overwrite the system ODBC, or your operating system to windows95/97 forget.

Then enter the "Oracle8 ODBC Driver Setup" setting, enter a name in "Data Source name" and enter the Oracle connection database string name in the "data source Service name" column. This can be found in the Tnsnames.ora file in your installed Oracle directory (ORACLE7 installation path is "Orawin95\network\ ADMIN"; Oracle8 installation path is "Orawin95\net80\admin"), Or you through "SQL Net easy Configuration" Add a new database connection configuration, the configuration of the string can be filled, the others do not have to fill in, to avoid the superfluous mistake, but not connected to the database.

Configuration of DB profile data source

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/pb/