using ADO and Oracle

rbuser

Our software uses ADO to connect to Oracle and MSSQLServer databases.
We would like to make a Development version of itwith the possibility to
edit templates without running delphi...

I started to test the TppDesigner component of RB 6.03 enterprise and it
seems to fit to what we wished but it doesnt work with Oracle by ADO
connection.
While searching if i had made an error i found the comment
{although Sybase and Oracle ran into trouble during testing of ADO,
perhaps future ADO drivers will work} in DaADO.pas.

Does a solution to that problem exists at the moment ?
(we'd like to have generic code not depending on the database type)


HENRY Frédéric

Jouve Rennes
12, rue des Landelles
Immeuble Hercule II
35510 CESSON SEVIGNE
FRANCE

Tél: 02.99.86.80.78
Fax: 02.99.86.98.01
Email: fhenry@rennes.jouve.fr

digitalmetaphors

We have DADE plugins which allow you to connect Oracle. You can use the
BDE, dbExpress, or DOA. Check out the readme file in the installed
RBuilder\Demos\EndUserDatabases\Oracle\DOA


Cheers,

Jim Bennett
Digital Metaphors Corp

rbuser

My question was more about using ADO for all our database types (oracle
and MSSQLServer). I saw the DOA possibility when i read your
documentation and we'll probably use it if we cant use a generic
solution but before coding a DatabaseType dependant solution i just
wanted to have more infos about ADO (if a patch could correct this/if a
new msdac version fixes it...)

Thanks

Henry Frédéric

digitalmetaphors

We looked in our DADE plugins, daADO.pas and daDOA.pas, and when we tried to
add Oracle support to daADO, we kept running into more problems (Oracle
errors). Unfortunately, you'll have to use DOA to connect to Oracle and ADO
to connect to SQLServer, with our end user DADE plugin architecture.


Cheers,

Jim Bennett
Digital Metaphors Corp