How to made ORACLE SQL request with ASP on IIS Windows server ?

Question

I will connect my ORACLE database to an IIS intranet server, working with ASP.NET

Answer 1

you have a couple options:

ado.net:

https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/oracle-and-adonet

odbc:

https://learn.microsoft.com/en-us/sql/odbc/microsoft/odbc-driver-for-oracle?view=sql-server-ver16

Answer 2

Hi @Villommet Jean-Luc,

As Bruce mentioned, currently you can still develop your applications using Oracle database in these two ways. But they will be removed in a future release, and Microsoft recommends that you use a third-party Oracle provider. I'm not sure if this will have any impact in your environment, but I think you have to consider it.

All in all, I recommend you use ODP.NET. Just refer to this doc: Developing .NET Applications for Oracle Database (On-Premises), which contains step-by-step instructions from installing the database to building and running the application. Hope this can help you.

Best regards,

Xudong Peng

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Install origin Oracle ODAC = "Oracle Data Access Components", it includes a Oracle library for .NET.

https://www.oracle.com/database/technologies/odac-downloads.html