How do I use another ASPNET provider aside from the default?

[Anonieko]

<!--
+-----------------------------------------------------+
| Case 1: |
| Using another SQL Server |
| Registered via aspent_regsql.exe utility |
| |
+-----------------------------------------------------+
-->

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer"
connectionString="Data Source=YOURSQLSERVER;Initial
Catalog=aspnetdb;Integrated Security=False;User
ID=user1;password=passw1"
providerName="System.Data.SqlClient"/>
</connectionStrings>
<!--
+--------------------------------------------------+
| Case 2: |
| Custom Provider maybe on another database |
| engine like Oracle, MsAccess |
+--------------------------------------------------+
-->

<connectionStrings>
<add name="AccessFileName" connectionString="~/App_Data/ASPNetDB.mdb"

providerName="System.Data.OleDb"/>
...
...other connection string aliases

<add name="ApplicationFileName"
connectionString="~/App_Data/seek.mdb"
providerName="System.Data.OleDb"/>
</connectionStrings>

....

<membership defaultProvider="AccessMembershipProvider">
<providers>
<add name="AccessMembershipProvider"
type="Samples.AccessProviders.AccessMembershipProv ider,
AccessProvider"
connectionStringName="AccessFileName"
enablePasswordRetrieval="false"
enablePasswordReset="false" requiresUniqueEmail="false"
requiresQuestionAndAnswer="false"
minRequiredPasswordLength="1"
minRequiredNonalphanumericCharacters="0"
applicationName="SampleSite" hashAlgorithmType="SHA1"
passwordFormat="Hashed"/>
</providers>
</membership>

<roleManager enabled="true" defaultProvider="AccessRoleProvider"
cacheRolesInCookie="true"
cookieName=".ASPXROLES" cookieTimeout="30" cookiePath="/"
cookieRequireSSL="false"
cookieSlidingExpiration="true" cookieProtection="All">
<providers>
<add name="AccessRoleProvider"
type="Samples.AccessProviders.AccessRoleProvider,
AccessProvider"
connectionStringName="AccessFileName"
applicationName="SampleSite"/>
</providers>
</roleManager>
<profile enabled="true" defaultProvider="AccessProfileProvider">
<providers>
<add name="AccessProfileProvider"
type="Samples.AccessProviders.AccessProfileProvide r,
AccessProvider"
connectionStringName="AccessFileName"
applicationName="SampleSite"
description="Stores and retrieves profile data from an
AccessProvider database."/>
</providers>
<properties>
<add name="FriendlyName" type="string" allowAnonymous="true"
serializeAs="String"/>
<add name="Height" type="int" allowAnonymous="true"
serializeAs="String"/>
<add name="Weight" type="int" allowAnonymous="true"
serializeAs="Xml"/>
</properties>
</profile>

<anonymousIdentification enabled="true" cookieName=".ASPXANONYMOUS"
cookieTimeout="100000" cookiePath="/" cookieRequireSSL="false"
cookieSlidingExpiration="true" cookieProtection="None" domain=""/>

<webParts>
<personalization defaultProvider="AccessPersonalizationProvider">
<providers>
<add name="AccessPersonalizationProvider"
type="Samples.AccessProviders.AccessPersonalizatio nProvider,
AccessProvider"
connectionStringName="AccessFileName"
applicationName="SampleSite"/>
</providers>
</personalization>
</webParts>

[Ken Cox - Microsoft MVP]

I'm not sure what your question is. You seem to have the providers in your
web.config.

If you're wondering how to switch providers, there's code here on loading
and initializing custom providers:

http://msdn.microsoft.com/library/de...ovMod_Prt8.asp
"Anonieko" <an******@hotmail.com> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...

<!--
+-----------------------------------------------------+
| Case 1: |
| Using another SQL Server |
| Registered via aspent_regsql.exe utility |
| |
+-----------------------------------------------------+
-->

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer"
connectionString="Data Source=YOURSQLSERVER;Initial
Catalog=aspnetdb;Integrated Security=False;User
ID=user1;password=passw1"
providerName="System.Data.SqlClient"/>
</connectionStrings>
<!--
+--------------------------------------------------+
| Case 2: |
| Custom Provider maybe on another database |
| engine like Oracle, MsAccess |
+--------------------------------------------------+
-->

<connectionStrings>
<add name="AccessFileName" connectionString="~/App_Data/ASPNetDB.mdb"

providerName="System.Data.OleDb"/>
...
...other connection string aliases

<add name="ApplicationFileName"
connectionString="~/App_Data/seek.mdb"
providerName="System.Data.OleDb"/>
</connectionStrings>

...

<membership defaultProvider="AccessMembershipProvider">
<providers>
<add name="AccessMembershipProvider"
type="Samples.AccessProviders.AccessMembershipProv ider,
AccessProvider"
connectionStringName="AccessFileName"
enablePasswordRetrieval="false"
enablePasswordReset="false" requiresUniqueEmail="false"
requiresQuestionAndAnswer="false"
minRequiredPasswordLength="1"
minRequiredNonalphanumericCharacters="0"
applicationName="SampleSite" hashAlgorithmType="SHA1"
passwordFormat="Hashed"/>
</providers>
</membership>

<roleManager enabled="true" defaultProvider="AccessRoleProvider"
cacheRolesInCookie="true"
cookieName=".ASPXROLES" cookieTimeout="30" cookiePath="/"
cookieRequireSSL="false"
cookieSlidingExpiration="true" cookieProtection="All">
<providers>
<add name="AccessRoleProvider"
type="Samples.AccessProviders.AccessRoleProvider,
AccessProvider"
connectionStringName="AccessFileName"
applicationName="SampleSite"/>
</providers>
</roleManager>
<profile enabled="true" defaultProvider="AccessProfileProvider">
<providers>
<add name="AccessProfileProvider"
type="Samples.AccessProviders.AccessProfileProvide r,
AccessProvider"
connectionStringName="AccessFileName"
applicationName="SampleSite"
description="Stores and retrieves profile data from an
AccessProvider database."/>
</providers>
<properties>
<add name="FriendlyName" type="string" allowAnonymous="true"
serializeAs="String"/>
<add name="Height" type="int" allowAnonymous="true"
serializeAs="String"/>
<add name="Weight" type="int" allowAnonymous="true"
serializeAs="Xml"/>
</properties>
</profile>

<anonymousIdentification enabled="true" cookieName=".ASPXANONYMOUS"
cookieTimeout="100000" cookiePath="/" cookieRequireSSL="false"
cookieSlidingExpiration="true" cookieProtection="None" domain=""/>

<webParts>
<personalization defaultProvider="AccessPersonalizationProvider">
<providers>
<add name="AccessPersonalizationProvider"
type="Samples.AccessProviders.AccessPersonalizatio nProvider,
AccessProvider"
connectionStringName="AccessFileName"
applicationName="SampleSite"/>
</providers>
</personalization>
</webParts>