Products

Solutions

Learn More

Partners

Community

Blog

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

SqlDataProvider

Return to previous page

  • 4/7/2015
  • 3713 Views

Comments

3713 Views

SqlDataProvider

Last updated 8 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