Re: Using both MS SQL and Oracle

Huh? since when is Transact-SQL a flavor of VBA?

And yes, Bryon as others have said it can be done. The SQL can be vastly different (at least in my Experience with Oracle 7.3 and SQL Server 6.5 it is). Particularly joins and other aggregate queries. Even the invocation of stored procedures is different 'exec' under SQL server and 'execute' under Oracle. So using stored procedures to hide the differences in code is not as simple as you may think.

"Rozi & George Goldberger" <ghita_at_worldnet.att.net> wrote in message news:DoRL6.7213$0W5.2833756_at_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 - 12:19:16 CDT