Re: Component between ADO & 9i

If you are intertest in writing a wrapper over C++ classes, take a look at SourcePro DB (yes, I do work on that product).

http://www.roguewave.com/products/sourcepro/db/

Although its not yet available in ADO interface, one can write a simple wrapper.
It gives you independence of SQL generation as correct SQL is generated from the C++ constructs that you have specified. If you want to change the generated SQL, just change the connect string used to obtain a RWDBDatabase object!

Want ease of development or performance? Why not get both! http://www.roguewave.com/products/sourcepro/db/

Turbo charge any C/C++ apps - without changing code! http://www.roguewave.com/ATSevan01

[Disclaimer: All views expressed here are my personal views

             and they can be incorrect at times]

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3eacfc94$0$29718$ed9e5944_at_reading.news.pipex.net...
> 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
> 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
> (HTML) that supports the multitude of browser clients out there it
surprises
> me that people imagine that writing transactional database apps
independent
> 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...
> > 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
> >
>
>
Received on Tue Apr 29 2003 - 01:33:50 CEST