Test app works on IIS but not the main app which sits in the same location in File Manager of the server

Hi,

I have an MVC app that connects from it's web config file using another class within it called PetaDb (derived from PetaPoco class). Now after deploying my app into IIS 10 and mind you I have changed my ProviderName to "SQLOLEDB" from the usual "System.Data.SqlClient" of my LocalDb, i'm getting this error message when trying to login to my app that's on a shared hosting server: An Error has occurred : Unable to find the requested .Net Framework Data Provider. It may not be installed. And reverting back on just those changes and keeping everything else the same, this is my error message: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)". So I then created a test app with the following stuff in it and had it reside next to my Web config file in File Manager of the server:
<%
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Provider=SQLOLEDB;Server=cassandra.aserv.co.za,1434;Database=mcageonj_db;UID=mcageonj_user;PWD=*********;"
cn.CommandTimeout = 900
cn.Close
Response.write("Connected Successfully")
%>. This works cause it tested successfully. So now what I want to know is what am I missing then... Please help!

0 answers