How To Use Managed ODP.NET in Classic ASP
(Doc ID 2674072.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Data Provider for .NET - Version 12.2.0.1 and laterMicrosoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
Goal
Generally ASP pages are written in VBScript (Unmanaged code) that are deployed on an IIS Website. You can not use Managed ODP.NET driver in classic ASP.
So we have to create a .NET Class Library to use the Oracle ManagedDataAccess component to connect to the Oracle Database and then use that .NET Library in ASP page.
Here in this document we use Visual studio to implement this requirement.
Note:
The sample program in this article is provided for educational purposes only and is NOT supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.
The sample program in this article is provided for educational purposes only and is NOT supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |