Hi,
I am in the process of developing a module and I am wondering how to have the module connect to a separate database from the DNN database that is installed. I have followed some procedures that I found through google trying to do this but my module is not using the correct connection string for some reason and is still trying to use the DNN database. The modifications that I have made so far are to the web.config file under Section group I added :
Code:
<section name="claims" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
under connectionStrings I added:
Code:
<add name="SQLServer" connectionString="Server=TempName;Database=Temp;User ID=exampleun;Password=examplepassword" providerName="System.Data.SqlClient"/>
and under <dotnetnuke> I added after the </data> tag
Code:
<claims defaultProvider="SqlDataProvider">
<providers>
<clear />
<add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SQLServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifer="" databaseOwner="dbo" />
</providers>
</claims>
The only other modifications I have made are to my module DataProvider.vb for the CreateProvider to be the following, so that it uses the claims connection and not the data connections:
Code:
Private Shared Sub CreateProvider()
objProvider = CType(Framework.Reflection.CreateObject("claims", "Modules.Contacts", ""), DataProvider)
End Sub
As well as a change to the SqlDataProvider to make under Private Members:
Code:
Private Const ProviderType As String = "claims"
As said before this will not use the correct Database when I go to the website. Am I missing something in my connection to the database?
Thanks,
Chris