Questions Prior to purchase of License

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
MainMeat
Posts: 12
Joined: Mon 02 May 2011 11:51

Questions Prior to purchase of License

Post by MainMeat » Mon 02 May 2011 11:57

Hello.

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.

MainMeat
Posts: 12
Joined: Mon 02 May 2011 11:51

Post by MainMeat » Wed 04 May 2011 07:49

Hi devart forum,

I know it is bad etiquette to repost, but I have still not received any response to this query from support or on the forum. Is there perhaps a change of receiving feedback regarding my question above prior to purchasing a license from Devart?

Many thanks

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Thu 05 May 2011 10:53

Hello,

I have tested your problems on ODAC with the latest version of Lazarus and FPC (Trial ODAC 7.20.0.6, FPC 2.4.2, Lazarus 0.9.30) on Linux OpenSuse 11.4 with Oracle Client 11gr2, and all applications (console and GUI) work fine. I can successfully connect to Oracle and execute a query in both cases.
Maybe the problem is connected with the fact that you don't set the correct enviroment settings, or your user doesn't have some permission.
Also maybe the problem is connected with your specific Linux (Fedora). Thereare many different Linux editions and we can't check our products on all of them.

MainMeat
Posts: 12
Joined: Mon 02 May 2011 11:51

Post by MainMeat » Fri 06 May 2011 08:03

Hi AlexP,

Thank you for you response. I updated my system to Ubuntu 11.04, and also updated to Lazarus 0.9.30 with FPC 2.4.2. Now everything appears to be working fine.

Next, I will get hold of a license to try Direct Mode which is waht I am after.

Thanks again!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Fri 06 May 2011 08:18

Hello,

Now the direct mode is not available for Lazarus. We plan to add it in one of the nearest versions of ODAC.

MainMeat
Posts: 12
Joined: Mon 02 May 2011 11:51

Post by MainMeat » Fri 06 May 2011 08:31

Hi,

Ok, so this means I need to continue to use the OCI DLL as currently tested?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Fri 06 May 2011 10:36

Hello,

Yes, for the time being you can connect to Oracle from Lazarus only in the OCI mode.

MainMeat
Posts: 12
Joined: Mon 02 May 2011 11:51

Post by MainMeat » Tue 10 May 2011 10:56

Hi AlexP,

I have purchased a license for the ODAC component but the download for Lazarus / Freepascal using Linux is not available in my subscription page. I have submitted an email to [email protected] and also [email protected] but am not receiving responses.

Can you please help?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Tue 10 May 2011 11:26

Hello,

Support for Lazarus is available only in editions with source code and trial edition.
You can see the compatibility list at http://www.devart.com/odac/compatibility.html or http://www.devart.com/odac/editions.html.
So you should upgrade your edition.

MainMeat
Posts: 12
Joined: Mon 02 May 2011 11:51

Post by MainMeat » Tue 10 May 2011 13:41

Hi AlexP,

hmmm.... :oops: did not quite understand initially but noted now.

So this means if I upgrade my current license from Professional ($249) and then purchase the edition upgrade to include source code ($199) I would finally have the version I am after?

Thanks

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Tue 10 May 2011 14:20

Hello,

Yes, you should upgrade your Professional edition to the Professional with source code edition. After that you can use ODAC with Lazarus.

Post Reply