Seems the be a faulty Oracle 64-bit installation.
Post can be closed

Hello F van Schaik,
we're facing the same problem as you in these days.
Could you please remember what was wrong with the previous Oracle installation? And what was the soution you found?
Thanks

Hi Marco,
I checked in depth the behavior and it seems to belong to DOA components.

I tried a simple application with a DOA Connection (TOracleSession) and a FireDAC connection (TFDCOnnection) against the same database.
The application is compiled in 64bit, Oracle Client 64bit is also correctly installed.

The DOA Connection works fine if the application is a dekstop exe. while it doesn't work if it is compiled as ISAPI library.
FireDAC connection works fine in both situations.
The class exception is EOracleError with an empty message.

I also verified that DOA connection works fine in IIS 7.x (Windows7) while doesn't work in IIS 8 and above (Windows10, Windows 2012, etc...).

Could you please verify it?

Can you send me your test project?

You can download a test project from
http://www.mondoedp.com/uploads/media/irisftp/download/Test_ISAPI_DO64.zip

Delphi 10.2.3 - It needs IntraWEB 15.
In Unit3 you have to assign the correct connection parameters.

Project1SA is the stand-alone exe version that woeks fine.
ProjectISAPI is the IIS-dll version that can't connect with TOracleSession.

Note: for some reason FDConnection must be connected first then DOA, I didn't investigate but it doesn't matter in this case.

Hello Marco,
was you able to see the test-project? Or you need something else?

Thanks

We will get to this shortly. I will post the results here.

Hi Marco,
any news about the problem with IIS 64bit?

Thank you

Excuse me Marco,
we really need to use our application in 64-bit IIS environment...
Could you please let me know?

I'm waiting for your reply.
Best regards.