Products

Solutions

Learn More

Partners

Community

Blog

About

SqlDataProvider

Return to previous page

  • 4/7/2015
  • 2886 Views

Comments

2886 Views

SqlDataProvider

Last updated 7 years ago

Comments

Common

(Enter the content of this article below)

Advanced

 
By default DotNetNuke ships with a sql data provider, which supports installation on sql server and sql server express products. This is defined in the web.config as follow:

<data defaultProvider="SqlDataProvider">

<providers>
<clear/>
<add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="" databaseOwner="dbo"/>
</providers>
</data>

Whilst most of this definition will not be changed, on occasion the upgradeConnectionString, objectQualifier or databaseOwner attributes are altered by some sites.
Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  

What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out