Re: Using both MS SQL and Oracle

From: Rozi & George Goldberger <ghita_at_worldnet.att.net>
Date: Mon, 14 May 2001 13:50:27 GMT
Message-ID: <DoRL6.7213$0W5.2833756@typhoon1.ba-dsg.net>

You would like a web app to look in both databases at the same time ? - you can do it
the SQL is different - regardless the name SQL the stored procedures are different MS uses a flavor of VBA and Oracle uses pl/sql

"Bday" <toiletpig_at_hotmail.com> wrote in message news:vQQL6.2625$Yh2.55113_at_NewsReader...
> Dear All,
>
> I'd like a web application to use both Oracle and MS SQL as a back-end
> database, but think that this would cause a problem.
>
> Can I use the same SQL commands for both?
> Can I use stored procedures?
>
> If anyone knows for sure, or has gone through similar pains, I'd greatly
> appriciate any helpful advise.
>
> cheers,
> Bryon.
>
>
Received on Mon May 14 2001 - 08:50:27 CDT