Active Server Pages and Oracle - best architecture?

I am looking for information that provides help in architecting an interface between ASP based web site and an oracle database.

Some questions that have come up are:

At what point should I concider a middle tier transaction server instead of simple ODBC conections?

How many connections can oracle handle? Any research that explains configuration of oracle multi threaded server settings would be helpful.

Does Oracle allow you to pass XML directly to the database? i.e to a stored procedure for example.

What options are there to avoid doing UPDATE, INSERT, DELETE directly from the ASP pages?

Thanks in advance for any reading suggestions or comments.

I will post my research on this site when done.

Matt

It could be that the purpose of your life is only to serve as a warning to others. Received on Wed Dec 04 2002 - 18:48:36 CET

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]