Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

Postgresql DADE RB 11

edited December 2008 in DADE
I am using D7 and Postgresql 8.3 with ADO connectivity. I have used the ADO
connection with a Pervasive database. I do not see Postgresql in the
database type drop down so I selected 'Other' (as I did with Pervasive). I
am able to create a DADE diagram but am getting syntax errors when I try to
preview my report.

Is there an additional step I should have taken to enable Postgresql?

thanks!

Sher

Comments

  • edited December 2008


    I researched this and the DADE plug-in for ADO needs a small mod. Try
    modifying daADO.pas, the method TdaADOSession.ValidDatabaseTypes contains a
    single line.

    change...

    Result := [dtMSAccess, dtMSSQLServer, dtSybaseASA, dtSybaseASE, dtOracle,
    dtOther];

    to...

    Result := [dtMSAccess, dtMSSQLServer, dtSybaseASA, dtSybaseASE, dtOracle,
    dtPostgreSQL, dtOther];


    Then copy the daADO.pas from RBuilder\Source to RBuilder\Lib and delete the
    corresponding .dcu. Build your project and test using the run-time designer.
    To fix Delphi design-time will require rebuilding the rbADOxx package and
    copying it to Windows\System32, then restarting Delphi.

    We can add this for the next maintenance release.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited December 2008
    That did it! Thanks for your help.

    Sher

This discussion has been closed.