Re: Component between ADO & 9i
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 28 Apr 2003 11:03:57 +0100
Message-ID: <3eacfc94$0$29718$ed9e5944_at_reading.news.pipex.net>
Date: Mon, 28 Apr 2003 11:03:57 +0100
Message-ID: <3eacfc94$0$29718$ed9e5944_at_reading.news.pipex.net>
[Quoted] A common approach to this is to write your own sql parser that spits out compliant sql for each database it supports.
However as the products are different with different design philosophies,
architecture and performance patterns I would suggest that it is impossible
[Quoted] to produce a database independent app that doesn't have problems with at
least one platform. In fact gicven that people can't even write strucutured
text
[Quoted] (HTML) that supports the multitude of browser clients out there it surprises
[Quoted] me that people imagine that writing transactional database apps independent
[Quoted] of the db app would be an easier task.
-- Niall Litchfield Oracle DBA Audit Commission UK "S" <bangormeNo_at_Spamhotmail.com> wrote in message news:LIlqa.533$c02.32100_at_eagle.america.net...Received on Mon Apr 28 2003 - 12:03:57 CEST
> Is there something out there that would truly allow ADO to seamlessly
> interface Oracle 9i? So if one wrote a VB app using SQL 7 or Access
> as the backend, then using this product, one could use an Oracle 9i
> backend without tons of problems?
>
> Just wondering.
>
> Scott
>