Re: ASP and Oracle

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 17 Jul 2003 11:55:50 +0100
Message-ID: <3f1680b7$0$15037$ed9e5944@reading.news.pipex.net>

"Michael Rothwell" <marothwell_at_yahoo.com> wrote in message news:bf4pv1$b8d13$1_at_ID-131223.news.uni-berlin.de...
> I have been asked to look into porting an ASP system to an Oracle DB.
> Currently, they are using SQL Server and retrieving data via stored procs.
I
> know how to migrate the DB, but what work will have to be done to the ASP
code
> to be able to access the Oracle DB as well as the SQL Server DB?

It depends :(

You will presumably need to rewrite the stored procs with Oracle equivalents return a ref cursor for a recordset and at the very least change the oledb provider and install an Oracle client on the web server.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Thu Jul 17 2003 - 05:55:50 CDT