Women in Technology

Hear us Roar



Article:
  Building Web Parts, Part 1
Subject:   Apparently this demo requires SQL Server Express 2005
Date:   2005-05-26 21:28:34
From:   lwm
Response to: Apparently this demo requires SQL Server Express 2005

Hi Mark:
By default, web parts uses the SQL 2005 Express provider for data storage. To use SQL Server 2000, you need to do some work:


1. Use the aspnet_regsql.exe tool located in
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\ to prepare SQL Server 2000. Essentially it will add the aspnetdb database.


2. In Web.config, add the following:


<connectionStrings>
<add name="myconnstring"
connectionString="Data Source=your_server_name;Initial Catalog=aspnetdb;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>


<system.web>
...
...


<webParts>
<personalization
defaultProvider="SqlPersonalizationProvider">
<providers>
<add name="SqlPersonalizationProvider"
type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider"
connectionStringName="myconnstring"
applicationName="/" />
</providers>
<authorization>
<deny users="*" verbs="enterSharedScope" />
<allow users="*" verbs="modifyState" />
</authorization>
</personalization>
</webParts>
</system.web>


That should work fine for you.


Hope it helps.
BTW, Firefox doesn't seem to work too well with Web parts.


regards,
Wei-Meng

Full Threads Oldest First

Showing messages 1 through 3 of 3.

  • Apparently this demo requires SQL Server Express 2005
    2007-04-19 22:17:30  shhhh [View]

    when i use this code in web.config,it gives following error:
    Parser Error Message: The provider 'SqlPersonalizationProvider' specified for the defaultProvider does not exist in the providers collection.

    Source Error:


    Line 129:
    Line 130: <webParts>
    Line 131: <personalization defaultProvider="SqlPersonalizationProvider">
    Line 132: <providers>
    Line 133: <clear/>

  • Firefox and AJAX capabilities for WebParts
    2006-07-23 22:55:48  dipg [View]

    Found this usercontrol on www.smartjungle.com which provides a WebParts control to get AJAX capabilities and complete Firefox compatibility with no extra code.
    http://www.smartjungle.com
    Demos:
    http://www.smartjungle.com/Demos.aspx

  • Apparently this demo requires SQL Server Express 2005
    2006-01-21 14:08:59  thompson1022 [View]

    I have sql 2005 and was experiencing the same issue. This solution worked for me. Thank you very much.

    Jeff