Let me begin by saying that I'm not trying to install DotNetNuke in an Oracle Database. Our issue is that we run PeopleSoft inside of Oracle, and a lot of the forms that we'd like to create, have data that exists in Oracle tables.
I'm familiar with writing my own modules that connect to Oracle, using System.Data.OracleClient. However, I've been tasked with getting modules like DataSpring's DynamicForms, and DNN's core reports module to pull from Oracle.
DataSprings said that if the query works in Host/SQL extension, then it would work for them. When I try this, I get the following error: "System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. " I am 100% sure that my connection string is fine, and it calls the correct provider: "System.Data.OracleClient." If I'm defining an oracle provider, why is DNN still using the SqlClient provider? Is there no other way around this?