Probable new user thinking of migrating ADO to ODAC

upsys · Post by **upsys** » Sun 16 Sep 2007 09:04

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,

Plash · Post by **Plash** » Mon 17 Sep 2007 08:43

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.

upsys · Post by **upsys** » Mon 17 Sep 2007 16:33

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,

Plash · Post by **Plash** » Tue 18 Sep 2007 07:34

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