p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: ASP.NET MVC Website Programming Problem Design Solution ISBN: 9780470410950 (http://p2p.wrox.com/forumdisplay.php?f=472)
-   -   Difficulties with "web.config" and "ASPNETDB" (http://p2p.wrox.com/showthread.php?t=76700)

CFRham October 22nd, 2009 03:43 AM

Difficulties with "web.config" and "ASPNETDB"

Thank you for this great book that's advancing my knowledge in MVC. I have got two quesions, a specific one and general one.

1. Specific question.

On the very top of the page 116, it is said:


...you will also need to create a user for your application to use in order to access the newly created database. To do this, expand the Security folder, right-click the Logins folder, and select New Login...
Here is what I did. When the "New login" dialog box appeared, I wrote "TheBeerHouse" in the login name textbox. Then I went to the UserMapping page and gave the user the db_datareader and db_datawriter rights. When I run it, I get the following exception:


An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. (Microsoft SQL Server, Error: 1038)
How and when theBeerHouse was created????! Could you be more specific either by giving the steps or by pointing me to some ressources that can help me.

2. General question

I remember that to create ASPNETDB in webforms, I just need to run a page that has on it a control, suah as CreateUserWizard. Also, if I decide to use the built in security module of MVC, I just need to create a new user to get the ASPNETDB appear under the App_Data folder.

In TheBeerHouse sample:
-We add the appropriate entries in the "web.config"
-We create TheBeerHouse DataBase

So, when do we get our DB be populated with tables??? When we run the application???? How TheBeerHouseUser was created????

I've been struggling with these concepts for days now. Any help will really jumpstart my MVC learning.

Thank you for helping me.

CFRham October 24th, 2009 10:09 AM


I was expecting some helps. That's ok, I was able to solve the problem using my other books.

Thanks anyway

fh84 July 3rd, 2010 10:19 AM

CFRham i've got the same problem with you!

Could anyone please give more instructions how to import the schema in Visual Studio?

when i run aspnet_regsql.exe run without any error, but when i check in the visual studio does not seems to be loaded!

could anyone please give some answers?

thank you in advanced!!!!

All times are GMT -4. The time now is 07:56 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.