Postgresql DADE RB 11

rbuser

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

nardmoseley

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

rbuser

That did it! Thanks for your help.

Sher