ODAC support?

waeberd

Hi,

Does FastReport support the (excellent) ODAC library from corelabs?
http://www.crlab.com

Thanks!

Daniel

AlexTZ

There is no DB engine for it yet. You can use only application-defined ODAC datasets.

BruceBiddle

Hi Daniel

I've been using ODAC with FR since 2.4+ and it works really well.

I had to wrote my own DB engine originally but theres is one available on the old Yahoo groups site (http://groups.yahoo.com/group/fastreport )frODACD6.zip.

It's only for FR2.4/2.5 only, not V3. If you want one for V3 then you would have to write it or you could try using the Fast Report "New Engine" tool to create one. This still leaves a fair bit of work to do, mainly because of the Database component/connection (TOraSession).

I've just upgraded to V3 so it's on my list of things to do but I won't get around to it for a couple of months yet. It does however look a little easier to to create you own DB enginge in V3.

I'll make mine available when done unless someone else does it in the meantime.

Regards

Bruce

waeberd

Thanks guys, maybe the ODAC guys will do some work on this...

The Session/Database stuff has to be set correctly, I found the wizard and I'll have to look at it when I have more time. Let's see if there's an ODAC-engine until then

So until then I cannot use ODAC queries in the script engine, right?
(I'd like to do some inline SQL in the report designer... any ideas? ).

Thanks again for your help!

Daniel

BruceBiddle

>So until then I cannot use ODAC queries in the script
>engine, right?

The only way is use TOraDataSet outside of the report and link/select it for the bands data source. It works fine but you just cant save the SQL/component in with the report.

Bruce

Hmm... Lets try something here

"HELLO!" has anyone out there got an ODAC DB Engine for Version 3 to share with Daniel?

waeberd

BruceBiddle wrote:

Hmm... Lets try something here

"HELLO!" has anyone out there got an ODAC DB Engine for Version 3 to share with Daniel?

Thanks buddy.... maybe I'll do some compare of the ODAC-FRv2 code with the new created templates.... the database / session stuff should not be very different to handle! Need some time though.... too busy (as usual)!

Cheers,

Daniel