AspNetSqlProvider

AspNetSqlProvider

• Peter Gubanov

  Please post ASP.NET related questions in the ASP.NET forum. The UI experts there can better answer your questions. Please reserve this forum for C#-specific questions.

  Thanks,

  Michael Taylor - 3/1/06

  
  

• Patrick van Strien

  which place of my code should i check the connection
  more explaining:
  I did the following steps:
  first i created the data base then i created web part manager
  after that i created webpart zone
  so i want to ask you is web part manager
  and webpart zone make connection automaticly
  by connection to aspnet_db
  if i make a mistake in my idea
  please tell me how can i connect the controls to aspnet_db
  i am sorry for heavy
  
  

• David Guyer MSFT

  Can't you debug the application, on the statements you get the exception you just look at the ConnectionString property of the connection object.
  
  
  

• maxascent

  Please, let me help you. First you need to look what the connection string is that is used, can you provide it
  
  Then you must check if the database exists, i think that is the point where the problem is. But first, check the connection string because then you will know wish database will be used.
  
  
  

• Red Maple

  Dear

  in your Link I found this Assumption :

  This tutorial assumes you are familiar with Data Access Controls and Data Binding Controls such as SqlDataSource and GridView. Also it requires SQL Sever 2005 Express Edition and Visual Web Developer. If you don't have SQL Server Express 2005, install ASPNETDB in your SQL Server instance using aspnet_regsql tool. and configure your application to use this instance as your personalization provider

  frankly i did what is desired

  the database was installed and i could view it from Sqlserver managment

  but when i try to execute my web application which contain webpart zone

  i had exeption which was included in my previous reply
  

  
  
  

• aleex

  I cheak the connection after that i

  have this Exception:

  The specified personalization provider, 'aspnetsqlprovider', is not registered.
  

  and when i try to register it from Asp.net web application Administration

  and go to Provider and click on Select a single provider for all site management data

  and test my AspNetSqlProvider 

  then i have this execption

  Could not establish a connection to the database.
  If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.

  although i create the database and used aspnet_regsql

  without no benefit

  
  
  

• Daniel Hilgarth

  Dear PJ. van de Sande

  I use local connection

  this is the err msg if i used a connection to sqlserver 2005 not sqlexpress

  (The specified personalization provider, 'aspnetsqlprovider', is not registered.)

  have you any way to running webpartzon control with sqlserver 2005

  
  
  

• Pankaj Sharma

  The error message is very clear, it doesn't allow remote connections.
  
  
  

• Will Sullivan

  No problem! Enjoy dinner
  
  
  

• inthegroove

  There are tons of example on the internet, just take a look here for example. But SQL Server 2005 isn't diffent then the Express Edition, only the Express Edition is a stripped version.
  
  
  

• JoseVargheseKonooran

  And when you look with the Enterprise Manager if the database exists
  
  
  

• Dennis de Jong

  Dear

  to resolve my problem

  I suggest send to me a simple application which use webpartzone control by connection to sqlserver2005
  thanks

  
  

  
  
  

• LeeH1972

  Thanks for you fast reply!

  What is you connection string and how do you make your connection, give us some code.
  

  
  
  

• landonec

  Dear
  now in company my time is finished
  I had finished my Work

  tomorrow I will continue with you
  thanks for your help
  

  
  
  
• AspNetSqlProvider