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? |
|
Andrei Smolin
Add-in Express team
Posts: 18661
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 |
|
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. |
|
Andrei Smolin
Add-in Express team
Posts: 18661
Joined: 2006-05-11
|
Hello Tamas,
Congratulations and thanks!
Regards from Poland (GMT+1),
Andrei Smolin
Add-in Express Team Leader |
|