ODAC support?

Comments

• AlexTZ

  September 2004 edited 3:24AM

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

  September 2004 edited 3:24AM

  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

  September 2004 edited 3:24AM

  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 Nottingham UK

  September 2004 edited 3:24AM

  >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

  September 2004 edited 3:24AM

  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