64 bit problem

[MYA]

Hi,

i didnt work on the 64 bit oracle system. i am using v4.1.1 and delphi 2007.

i tried to use the 32bit oci DLL (OCIDLL:='d:\oracle\ora92\bin\oci') but it didnt work. i encountered a blank error message.

note: if i change the ORACLE_HOME environment variable on the system, it works. but i dont want to change it.. because in this instance sqlplus isnt working

thanks,

 

[Marco Kalter]

You will need to install a 32 Bit Oracle Client. Delphi generates 32 Bit applications, so it cannot interface with a 64 Bit Oracle Client.

The 32 Bit Oracle Client can communicate with a 64 Bit Server, even on the same machine if necessary. The 32 Bit client can coexist with a 64 Bit Oracle installation when installed in separate Oracle Home directories.

 

[MYA]

Hi,

i succeeded to operate on the 64 bit with the 32 bit client without the 32 bit client installation.

i assigned the variable "OCIDLL" with "32 bit oci.dll" and set 'ORACLE_HOME' system environment manually

thanks..

for example :

DefaultOCIDLL:=false;
DefaultHomeName:=false;
OCIDLL:='D:\oracle\ora92\bin\oci.dll';
SetEnvVarValue('ORACLE_HOME','D:\oracle\ora92\');

---

function SetEnvVarValue(const VarName, VarValue: string): Integer;
begin
// Simply call API function
if SetEnvironmentVariable(PChar(VarName),
PChar(VarValue)) then
Result := 0
else
Result := GetLastError;
end;