Client None does not have Oracle method
Guangdong Zhongshan Xie Dianhong
2001/04/03
Preface:
I saw many people asking the client side without installing Oracle, and the PB program continued to connect to the background Oracle database.
I have been engaged in PB Oracle development, I have to install Oracle's Client Routing every time, and I face it.
There are hundreds of people in the client, and the workload can be big, so it is moving under this area, after repeated
Test, finally got it.
Development Environment: Front desk: PB6.5 Win95 Oracle 7.3.4 Client Background: Redhat Linux 6.2 Oracle 8.1.6
Configuration for Oracle Database Alias: (% ORACLE_HOMES% means Oracle installation directory)
When configuring an Oracle database alias in SQL NETEASIY Configuration, different from SQL Server 7 and ODBC are
Oracle does not write the database alias information into the registry, but written in a text file:
% Oracle_Homes% / Network / Admin / TNSNames.ora, (this file is used with SQLNET.ORA in the same directory), when running the PB
When the order is actually read the database configuration information in the two files.
The file required by the application:
Archive name
File source
Pbvm60.dll
C: / program files / sybase / share is essential
PBDWE60.DLL
C: / program files / sybase / share is essential
Pbo7360.dll
C: / program files / sybase / share is essential
Ociw32.dll
% Oracle_Homes% / BIN is essential
Core35o.dll
% Oracle_Homes% / BIN is essential
NLSRTL32.DLL
% Oracle_Homes% / BIN is essential
Core35.dll
% Oracle_Homes% / BIN is essential
Ora73.dll
% Oracle_Homes% / BIN is essential
Ncrnt.dll
% Oracle_Homes% / BIN is essential
Nnfnnt.dll
% Oracle_Homes% / BIN is essential
NNFDNT.DLL
% Oracle_Homes% / BIN is essential
NTNT.dll
% Oracle_Homes% / BIN is essential
Otrace73.dll
% Oracle_Homes% / BIN is essential
NLNT.DLL
% Oracle_Homes% / BIN is essential
NASNSNT.DLL
% Oracle_Homes% / BIN is essential
Nsnt.dll
% Oracle_Homes% / BIN is essential
SQLTNSNT.DLL
% Oracle_Homes% / BIN is essential
NTTNT.DLL
% Oracle_Homes% / BIN is essential
Ntnnt.dll
% Oracle_Homes% / BIN is essential
Tnsnames.ora
% Oracle_Homes% / Network / Admin
SQLNET.ORA
% Oracle_Homes% / Network / Admin
Lx * .nlb
% Oracle_homes% / NLSRTL32 / DATA has a total of 414 files, of which lx3 * .nlb (63 files) does not need,
The remaining 351 documents are essential, all file size is no more than 2m,
test environment:
I found a new computer, install win98, create a new directory: c: / test, copy the above files to this directory, modify the registry: // hkey_local_machine / Software under the content
Add a child under Software: Oracle
Select Oracle, add two string values in the right pane:
NLSRTL32 is: C: / Test
NLS_LANG is: traditional Chinese_taiwan.zht16big5
Where NLSRTL32 is the search path to the * .nlb file, NLS_LANG is the symbol of Oracle, I
Traditional Chinese is used in the test.
After that, I found two unsettled Oracle's computer tests, and tried did not know.
Description: If PB7 or ORACLE8, the above file is changed, there are some DLL files under C: / Windows / System,
Such as: NetBIOS.dll et al. Is Windows itself, so please consider it when you are not included.
With tools: SAX SETUP 6.0
SAX SETUP is a fairly easy to install packaging tool, which has a biggest feature that can detect an application.
DLL files required for runtime, but other types of files cannot be detected, and the registration is available.
SAX SETUP 6.0 registration code: 3160-3194666-18
Postscript: The above process, I spent nearly 4 days, I hope to help PB Oracle developers, but please pay,
According to the source, respect the author's labor, please tell us more than if there is an incorrect place.
