Topic: Exception EOCIDBEerror
|
|
Jo
User
Fresh Boarder
| Posts: 7 |   |
Karma: 0
|
|
Exception EOCIDBEerror
|
|
Posted: 2000/09/05 01:41 |
|
|
|
|
Hi from Argentina !
The component looks fine, but I had problems using the components
Let me introduce my computer configuration
WinNT 4.0 Service Pack 3 128 MB
Oracle 8i Enterprice Edition 8.1.6
Delphi 5 Enterprice Edition Build 5.62
The problem are with the OCI.dll, I think. When I open the project a window
application Error appears
----------------------------------------------------------------------------------
Exception EOCIDBEerror in modile NCO85.blp at 000033B5
NOE3/INIT - Error when loading OCI dll. The system cannot find the file specified.
----------------------------------------------------------------------------------
Do I forget to set anything in Delphi ?, thanks in advance for this consult and for
the hard work you did with this components.
Jo
Jose Luis Valerio
jvalerio@movi.com.ar
jvalerio@hotmail.com
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Exception EOCIDBEerror
|
|
Posted: 2000/09/05 06:14 |
|
|
|
|
Hi Jose !
OCI.DLL is Oracle client library. Error "NOE3/INIT...." mean, that during loading of OCI.DLL WinNT returns error "The system cannot find the file specified". Could you verify next:
- you have correct installation of Oracle client software. Can you run SQLPlus ?
- is your ORACLE_HOMEBin directory in your PATH environment variable value ?
- can you locate in this directory OCI.DLL ?
|
|
Jo
User
Fresh Boarder
| Posts: 7 | |
Karma: 0
|
|
RE: Exception EOCIDBEerror
|
|
Posted: 2000/09/05 13:21 |
|
|
|
|
Hi !
All is working, sqlplus, OEM, svrmgrl, etc, the paths are ok in the instalation, but for some reason delphi can't find the library or load the library
Path=d elphi5vbrokerjreBin;delphi5vbrokerBin;d:oracle816bin;C rogramFilesOraclejre1.1.7bin;D:UTILIT~1BorlandvbrokerjreBin;D:UTILIT~1BorlandvbrokerBin;C:orantbin;
c:Rx;C:WINNTsystem32;C:WINNT;d:oracle816orbbin;D:oracle816bin;delphi5ProjectsBpl;delphi5Bin;D:UTILIT~1BorlandDelphi5ProjectsBpl;D:UTILIT~1BorlandDelphi5Bin
|
|
Jo
User
Fresh Boarder
| Posts: 7 | |
Karma: 0
|
|
RE: Exception EOCIDBEerror
|
|
Posted: 2000/09/05 14:45 |
|
|
|
|
This problem ocurrs when you have more that one Oracle Home, in my case I have two
DEFAULT_HOME C:ORANT Old Oracle Tools (805) Old Installation
OTHER_HOME D:ORACLE New Oracle Home 8i and OEM New Installation
My DEFAULT_HOME was empty, and this was the error reason, so I need to clean up it from registry and set as DEFAULT_HOME the OTHER_HOME. Be carefully when modified this.
The two homes can exist and works with different binaries versions, but when I use NCOCI8 components
delphi or NCOCI8 are looking to DEFAULT_HOME, I'll ask to Dmitry if he knows this problem, may be interesting can tell to Delphi which ORACLE_HOME to use.
Jose Luis Valerio
jvalerio@movi.com.ar
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Exception EOCIDBEerror
|
|
Posted: 2000/09/05 16:08 |
|
|
|
|
Hi Jose !
NCOCI8 loads client software from default Oracle home. By definition, default Oracle home, is the home wich has Bin directory at first in PATH environment variable. But it is good idea to give programmer ability to select ORACLE_HOME, that will be used by NCOCI8 !
|
|
wes
User
Fresh Boarder
| Posts: 1 | |
Karma: 0
|
|
RE: Exception EOCIDBEerror
|
|
Posted: 2000/09/06 12:14 |
|
|
|
|
I, also get an error when running a program on a machine that has multiple homes.
Having the ability to select the home to use would be a nice feature.
|
|
|
