Client-side devices that are insecure about Oracle and use PowerBuilder to connect directly

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.