Hi,

I was working with the DNN 4.9 version all this while. In the Web.config file, I had defined a new section in the <data defaultProvider="sqlDataProvider> like so:

<add name="My_New_DataProvider"
     type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
     connectionStringName="NewSqlServer"
     upgradeConnectionString=""
     providerPath="~\Providers\DataProviders\SqlDataProvider\"
     objectQualifier=""
     databaseOwner="dbo"/>

And then I could access the database by specifying the connection string in the <connectionStrings> section like so:

<add name="NewSqlServer" connectionString="Data Source=QA;Initial Catalog=NewDB;User ID=DbUser;Password=DbUserpwd" providerName="System.Data.SqlClient" />

However, in the dnn version 5.1.3, when I add the dataprovider info in the <data defaultProvider.. section (the part in red above) the whole dnn site crashes and I cannot even load any page in DNN. In the eventViewer, I get an error entry saying .net runtime 2.0 error, Faulting application w3wp.exe etc...

Please can some one tell me why this happens? If I remove the above red section from the web config file, every thing is fine again.

Any help in this matter will be greatly appreciated,

Thanks.

AFAIK you only need the connection string to access your extra data, the provider is reserved for DNN internal use (if you want to switch to oracle, e.g.).

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

Errr forget that last message, adding that into my web.config also kills the website. Please create an issue on http://support.dotnetnuke.com to see if this can get resolved in a future release.

---

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions