Re: Urgent:: Use of COM/COM+ and XML data to interface Oracle DB, best practices

Before anyone answers you, maybe you could explain how your problem is so much more urgent then anyone else's?

"news.online.no" <stein-a4_at_online.no> wrote in message news:ZrBM9.2876$CG6.49627_at_news4.e.nsc.no...
> Hi
> Good advice for how to most efficent generate XML-Data from "datasets" in
 an
> oracle database would be apriciated, the ability to use SQL-Server would
 be
> an advantage,
>
> I need to make a set of COM/COM+ functions available as an API to
 distribute
> data in an existsing application (200/300 tables), and eventually replace
> the current DB-application-interface. The current implementation will be
> done in VB6, the intention is to eventually move to .NET and web-services.
> I will be using XML as the data-interface language, the intention is that
> the COM/ COM+ objects will be responsible for:
>
> 1. Receiving data request/manipulation commands in an XML-format, and
> generate and run SQL's
> 2. Formatting the data and returning authorized data to the user-program
 as
> an xml-string
>
> The XML data definitions is intended to hide some of db-complexity and
 will
> in most cases span several tables, this to incorporate type definitions
 and
> information about "childs-/specialised-nodes".
>
> Stein
>
>
>
Received on Fri Dec 20 2002 - 23:04:36 CET