Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Problem !!!
Problem !!!
Posted: 2005/09/29 16:25
 
Hi Everyone.


I writing this with a hope that you can give me a tip or an advise. We have a big problem with application which is based on library NC OCI8. The library is used to connect application with oracle 9i database. Our problem is that when one is logged as a USER under WIN XP we have information like this “NOE1/INIT - OCI not properly installed on this machine”. Of course after that nothings happen and communication with db is off. The only one solution for this problem is to grant a local administrator’s priviledge to every user in our network. Unfortunately it is against our company secure policy. Do you have any idea what we can do to change this situation? Thank you for every possible help.

Greetings
RE: Problem !!!
Posted: 2005/09/29 18:18
 
Noci looks at the registry to find where is the oci.dll. Perhaps the keys looked at are protected or wrong. Take a look at NCOci.pas and hard code the right place:

reg := TRegistry.Create;
with reg do
try
RootKey := HKEY_LOCAL_MACHINE;
InitBest;
if TestBestHome('SoftwareOracle') then
{$IFDEF OCI_D4}
if OpenKeyReadOnly('SoftwareOracleAll_Homes') then begin
{$ELSE}
if OpenKey('SoftwareOracleAll_Homes', False) then begin
{$ENDIF}
s := ReadString('HOME_COUNTER');
if s = '' then
n := 1
else
n := StrToInt(s);
for i := 0 to n - 1 do
TestBestHome('SoftwareOracleHome' + IntToStr(i));
end;

//smbrant a fix to be seen later:
FOCIOracleHome:= 'C:Oracleproduct10.1.0Client_3';

[]s
RE: Problem !!!
Posted: 2005/09/30 11:07
 
Thank you for your replay but I can't use your advice. I can't use it because i have not acess to source code. Anyway I can't do nothing with that. Do you now (and can you tell me) which keys and how I should modify.
RE: Problem !!!
Posted: 2005/10/21 13:24
 
the solution is to give your users the read-right (may be write too, not sure now) on the oracle directory.
thats why giving them the admin right helps, now they can read the directoy.