Client-side devices that are insecure about Oracle and use PowerBuilder to connect directly
Last Update:2017-02-28
Source: Internet
Author: User
Client|oracle
Client-side approach to installing Oracle
Cantonese Zhongshan Thank you macro
2001/04/03
Objective:
I've seen a lot of people on the Internet asking the client to connect a PB program to an Oracle library by not installing Oracle,
I've been in pb+oracle for some time, and I've had to install Oracle's client programs every single day, and I
The client side has a few hundreds, and the amount of work can be imagined, so it's the brain that's going through the back
The experiment is finally done.
Development environment: Front: pb6.5+win95+oracle 7.3.4 Client: Redhat Linux 6.2+oracle 8.1.6
Configuration of Oracle Repository name: (%oracle_homes% for Oracle's installation record)
When you configure Oracle library names in SQL Neteasy configuration, unlike SQL Server 7 and ODBC,
Oracle did not write the data in the registration form, but wrote it into a text file:
%oracle_homes%\network\admin\tnsnames.ora, (this file is used in conjunction with the Sqlnet.ora), when running PB
Sequence, you actually read the data library configuration information in these two files.
Files needed to run the application:
File name
File source
Pbvm60.dll
C:\program Files Ybase Hare Essential
Pbdwe60.dll
C:\program Files Ybase Hare Essential
Pbo7360.dll
C:\program Files Ybase Hare Essential
Ociw32.dll
%oracle_homes%\bin Essential
Core35o.dll
%oracle_homes%\bin Essential
Nlsrtl32.dll
%oracle_homes%\bin Essential
Core35.dll
%oracle_homes%\bin Essential
Ora73.dll
%oracle_homes%\bin Essential
Ncrnt.dll
%oracle_homes%\bin Essential
Nnfnnt.dll
%oracle_homes%\bin Essential
Nnfdnt.dll
%oracle_homes%\bin Essential
Ntnt.dll
%oracle_homes%\bin Essential
Otrace73.dll
%oracle_homes%\bin Essential
Nlnt.dll
%oracle_homes%\bin Essential
Nasnsnt.dll
%oracle_homes%\bin Essential
Nsnt.dll
%oracle_homes%\bin Essential
Sqltnsnt.dll
%oracle_homes%\bin Essential
Nttnt.dll
%oracle_homes%\bin Essential
Ntnnt.dll
%oracle_homes%\bin Essential
Tnsnames.ora
%oracle_homes%\network\admin Essential
Sqlnet.ora
%oracle_homes%\network\admin Essential
Lx*.nlb
%oracle_homes%\nlsrtl32\data A total of 414 files, of which, LX3*.NLB (63 files) are not required,
The remaining 351 files are essential, all file sizes are not exceeding 2M,
Test environment:
I found a new computer, mounted Win98, and set up a new catalogue: C:\test, copy this document to this catalogue,
To modify the registration form: \\HKEY_LOCAL_MACHINE Oftware under the content
Add a subkey under Software: ORACLE
Choose Oracle and add two string values to the right pane:
NLSRTL32 its value as: C:\TEST
Nls_lang its value as: traditional Chinese_taiwan. Zht16big5
Among them, NLSRTL32 is for *. The NLB file indicates the search path, and Nls_lang is a set of Oracle-indicating characters that I
The tests were made with Chinese.
Then I found two computer tests that were not installed in Oracle and floundering.
Explain: If PB7 or ORACLE8, please change the above documents, some DLL files are located under C:\windows ystem,
such as: Netbios.dll is owned by Windows, so it is not included in the actual industry, please consider as appropriate.
Using tools: Sax Setup 6.0
Sax Setup is a simple, easy-to-use installation kit that has one of the biggest features is the ability to detect applications
DLL files needed to run, but no other types of files can be detected, and the version will be registered.
The 3160-3194666-18 for Sax Setup 6.0:
After that, I spent nearly 4 days in the hope of helping the pb+oracle, but when you do this, please,
Note the place, respect the author's labor, the above content if there are some wrong places also please letter pointed out, a lot of exchanges.