[thelist] Connecting ASP to Oracle

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Chris Johnston" <chris at fuzzylizard.com>
Subject: [thelist] Connecting ASP to Oracle


: I have just a small question for a Wednesday morning. I am
: looking for some good documentation on how to connect ASP
: to an Oracle database. (I am not sure if it is ASP3 or ASP.net
: so sources for both would appreciated)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

In ASP, you'd use ADO objects. In ASP.NET you'd use ADO.NET objects. Your
ADO objects would use either an ODBC Driver, or an OLEDB Provider for Oracle
(both are available). Your ADO.NET objects can use either an OLEDB Provider
for Oracle, or the native Oracle client (which is available from Oracle, and
there's also an implementation available from Microsoft).

Other than installing the relevant ODBC Driver/OLEDB Provider/Native
Provider, you just need to provide a connection string:
http://www.able-consulting.com/ADO_Conn.htm for a comprehensive list.

Cheers
Ken