ASP and Oracle

#1

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?
--
Michael Rothwell

#2

"Michael Rothwell" <marothwell (AT) yahoo (DOT) com> wrote

Quote:

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

#3

Hello, After reading the other 2 replies, I was thinking about the
autonumbering in SQL Server and the Sequences in Oracle. I had to chg a
fair amount of ASP code for this conversion. Please review that possibility.
for me in 2002, it was a little bit of a challenge. For more if requested.

PS: the 2 other replies are excellent ideas.

Michael Vick

"Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> wrote

Quote:

"Michael Rothwell" <marothwell (AT) yahoo (DOT) com> wrote in message
news:bf4pv1$b8d13$1 (AT) ID-131223 (DOT) 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

#4

Daniel Morgan wrote:

Quote:

Michael Rothwell wrote:

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?
--
Michael Rothwell

You do understand you will need to rewrite every proc to have a REF CURSOR as an
OUT parameter?

If connecting via ODBC and all SQL is in the procs ... essentially nothing need be
changed. If the SQL is being
passed through ... everything needs to be rewritten.

Yes, I am aware that I would have to re-write all the procs, and I had counted
on that.

All SQL is in the procs, so what I dont know is how ASP is written to make these
calls. After I change the procs and the ODBC connection, what needs to be done
to the ASP code?

Quote:

And if you don't take multi-versioning and the Oracle transaction model into
account you will just make a huge,
unscalable poorly performing mess.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

--
Michael Rothwell
Oracle/Sql Server DBA/Developer/Web Enabled DB's
HTTP://www.bdbinc.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ASP and Oracle

comp.databases.oracle.misc comp.databases.oracle.misc

ASP and Oracle - 07-16-2003 , 07:17 PM

Re: ASP and Oracle - 07-17-2003 , 05:55 AM

Re: ASP and Oracle - 07-17-2003 , 11:11 AM

Re: ASP and Oracle - 07-17-2003 , 02:15 PM