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

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