Devart Forums

Hi, I have an app that currently uses ODBC via ADO to access Oracle.

I would like to migrate to a direct Oracle connection using ODAC, so Oracle client files are no longer needed on the client computer.

My application currently uses the standard set of components:

TADODataset -> TDataSetProvider -> TClientDataSet

The ODBC driver is defined in the ConnectionString property of the ADO datdaset.

I use very simple SQL statements in the CommandText property of the ADO dataset - nothing Oracle specific.

A couple of questions:

1. I believe I need minimum of Professional edition ODAC for direct connection - is this correct?

2. For my simple requirements, is migration just a case of replacing TADODataset with TORAQuery and changing my code to put the SQL in the right property of the TORAQuery component - or is there lots of other work I would also need to do to get simple queries up and running on ODAC?

This is just to give me some idea of what I might be taking on!

Many thanks,

1. Yes, you need the ODAC Professional edition to use connection in Direct mode.

2. You should replace TADODataSet components with TOraQuery components, and you should place the TOraSession component to one of your forms. Possibly, you will need to do some small changes in your Pascal code.

Good, sounds as though my impression of the migration work is about right.

I've downloaded the trial version, if all goes well I'll be back to purchase within a few days.

Do I have to install again when going from trial to licensed version, or is it just a case of entering my license code to release any restrictions?

Thanks,

You will need to uninstall the Trial Edition and then install non-Trial one.