Single application - multiple target databases - which DB driver?

From: William Malloch (no_at_email.com)
Date: 11/01/04 

Date: Mon, 01 Nov 2004 17:28:28 GMT

I'd be interested in peoples thoughts on which database driver(s) to
use for an application where the target db varies....

Currently our main application is Oracle based using Direct Oracle
Access from AllroundAutomations, been using it for years and have no
complaints.

We now have to supply the same application but the back-end db is mySQL
and are looking at how to keep basically the same code but have to
ability to switch database type.

My initials thoughts were to have multiple datamodules, one for each
target DB (DOA, myDAC and possible SDAC to support MSSQL Server) and
switch them at compile time, but now, having looked at SQLDirect,
perhaps a single datamodule could be used?

Our applications are D7/Win32 and also D7/Win32/Intraweb services and
we will be upgrading to Delphi 2005 as soon as it's released, we also
use ReportBuilder 7 Enterprise.

Any comments would be appreciated, particularly users of SQLDirect
(Pros and Cons of SQLDirect) as the single datamodule approach would be
prefered but is it realistic?

Thanks
Bill

Relevant Pages

  • Re: losing precision while selecting NUMBER values from Oracle 7.3
    ... > DBI script selects/displays 39 digits after the decimal point, ... > digits from target, which is a Oracle 8 database. ...
    (perl.dbi.users)
  • losing precision while selecting NUMBER values from Oracle 7.3
    ... Source db is Oracle 7.3 and target db is Oracle 8.1.7. ... DBI script selects/displays 39 digits after the decimal point, ... which is a Oracle 8 database. ...
    (perl.dbi.users)
  • CProviderTypes - Doubt
    ... I need to create some intermediate temp tables in the target ... database as same as the source. ... Server's but again it should be compatible for oracle. ... getting the right data type bcos OLEDB gives data type number to a group ...
    (microsoft.public.data.oledb)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • A cool DBA job wanted
    ... 7, Oracle 6, Sybase, SQL Server ... Proposed proactive database monitoring through ... strategies to administer remote Oracle databases ... Trained installation and support personnel in basic ...
    (comp.databases.oracle.server)