I'm trying to point to my SQL database for app data. I changed the newsProviderName="sqlProvider". With that, I get the error message: Object reference not set to an instance of an object. In particular the source error reads:
Line 22: string connectionStringName = sec.NewsProviders[sec.NewsProviderName].Parameters["connectionStringName"];
Line 23: return WebConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString;
By the way, I have successfully connected on test pages to the SQL database and VWD added the following connection string to the Web.Config file:
I have searched for weeks on how to add a connection string to the SQL database (along with table, username, password) to no avail. Can anyone answer this or point me to a general area I might find the answer? Any and ALL help would be most appreciated!!!