oracle connection problem in 64 bit add-in

Add-in Express™ Support Service
That's what is more important than anything else

oracle connection problem in 64 bit add-in
I cannot connect to oracle when calling from a 64-bit add-in 
Tamas Szabo




Posts: 28
Joined: 2008-07-03
Hello!

I would like to compile a 64-bit add-in for 64-bit word, but I have a problem with the oracle connection.
I created a small test program. I have a form with an oraclesession component.
When I compile a windows exe program from it, the oraclesession connects to the database without any problems.
It works in both 32 bit and 64 bit versions.
If I compile the same form into add-in dll and call it from a word, it works in 32 bit version,
but in 64 bit I get the following error message: Access violation at address 00007FFC035A31D3 in module 'OraClient.Dll'. Write of address 0000000000000018

try
mmoLog.Lines.Add('Start');

OracleSession.Connected := False;
OracleSession.LogonDatabase := FLogonDataBase;
OracleSession.LogonUsername := edtUser.Text;
OracleSession.LogonPassword := edtPassword.text;
mmoLog.Lines.Add('after dmDataMain.OracleSession.LogonDatabase := '+ FLogonDataBase);
OracleSession.Connected := True; // AV error in this row !
mmoLog.Lines.Add('after Connected: ' + BoolToStr(OracleSession.Connected, true));

except
on E: Exception do begin
mmoLog.Lines.Add('Connection failed!');
mmoLog.Lines.Add('FLogonDataBase:'+FLogonDataBase);
mmoLog.Lines.Add('Error:'+E.Message);
end;
end;

The operating system is windows 10, 64 bit. office is Office 365 64 bit. oracle cliens is also 64 bit.
I compiled with Delphi 10.3.

Have you encountered this problem? What is the solution?
Posted 19 Jan, 2023 05:57:17 Top
Andrei Smolin


Add-in Express team


Posts: 18794
Joined: 2006-05-11
Hello Tamas,

We don't use Oracle so we've never seen such a problem. I suggest googling. But first, check whether a newer version exists.

Regards from Poland (GMT+1),

Andrei Smolin
Add-in Express Team Leader
Posted 19 Jan, 2023 08:02:37 Top
Tamas Szabo




Posts: 28
Joined: 2008-07-03
Hello! I finally found a solution. I have corresponded with the developers of Direct Oracle Access and they have released a fix for this. So DOA version 4.1.4.1 fixes the oracle connect bug in the 64 bit plugin.
Posted 26 Jan, 2023 03:02:35 Top
Andrei Smolin


Add-in Express team


Posts: 18794
Joined: 2006-05-11
Hello Tamas,

Congratulations and thanks!

Regards from Poland (GMT+1),

Andrei Smolin
Add-in Express Team Leader
Posted 26 Jan, 2023 11:18:40 Top