I forwarded the question below to Devart support last week but did not get a response, therefor trying the forums
To whom it may concern:
I have been looking for Oracle Data Access Components for Lazarus FreePascal and came across devart and ODAC. Prior to purchasing a license, I wanted to test the ODAC component to ensure it will work in my environment and applications. I came across some interesting items as described below and would appreciate some detailed feedback:
I wrote three applications, one on a Windows platform to start initial testing of ODAC.
- First Application -
On Windows I wrote a simple console type application that connects to a Oracle Database and executes some queries. This application works fine and the only item noted is the message box displayed upon the ODAC component connecting to the database indicating I am using a trail license.
- Second Application -
Since my application will actually run on a Linux platform as a service (console type application again), I recompiled the application on a Fedora Linux platform, using Lazarus and Freepascal again. After setting the initial environment variables in order to use the oci.dll, the console application would not run and an access violation is noted when the ODAC component is trying to connect to the database with no additional information.
- Third Application -
I thought the issue with the second application is the licensing message box noted with the Windows Application that cannot be displayed when executing the application from a linux terminal / console. I then wrote another application that uses a form and is not a console application. When running this application from the Lazarus IDE in debug mode, an violation is noted that the application cannot see the oci.dll anymore. However, when launching the application from a linux terminal, the application works fine again and is able to connect to the Oracle database and is able execute some basic queries.
I therefor need clarification regarding the above mentioned scenarios. Is the issues noted in Linux due to the fact that I am using a trail license? Specifically, I really need to be assured that the ODAC component will work when running a console type application in linux where there is not GUI available to launch the application from?
Any feedback is highly appreciated.