I'm on a Windows 10 machine. I can connect to the Oracle database using ODP.net with my Visual Studio 2022 .NET application before I publish the application to IIS. I can connect to the database while developing and testing the code in Visual Studio.
However, once I publish the application on the same machine, I get an error. After I published the ASP.NET application to IIS, I get
ORA-12154: TNS: could not resolve the connect identifier specified
I'm using ODP.net managed driver to connect to the database.
Oracle.ManagedDataAccess, Version=4.122
My Oracle client is 21c (64 bit)