Invalid object name 'be_Blogs'.

Topics: ASP.NET 2.0
Jan 25, 2012 at 9:49 AM

i created database named BlogEngine instead if xml provider

and i updated the web.config of course and here is my code

Note:i use .net 3.5

 and changed the default provider like this

<blogProvider defaultProvider="DbBlogProvider"> 




  <add name="BlogEngine" connectionString="Data Source=.\SQLEXPRESS;initial catalog=BlogEngine;Integrated Security=True" providerName="System.Data.SqlClient"/>

  but when i run the default.aspx this error shown up:


Invalid object name 'be_Blogs'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'be_Blogs'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Jan 25, 2012 at 2:56 PM

You need to execute SQL scripts from "setup" folder to create database tables and load initial data. Check for a folder under "setup" corresponding to your database and run latest SQL script from that folder in DB tool like SQL management studio.