Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4: in C# and VB by Imar Spaanjaars; ISBN: 9780470502211
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 8th, 2012, 05:53 PM
Authorized User
Points: 134, Level: 2
Points: 134, Level: 2 Points: 134, Level: 2 Points: 134, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 22
Thanks: 0
Thanked 4 Times in 4 Posts
Default More Help with chapter 15

I am working on the try it out Hand-Coding Data Access Pages

when I try to connect the DropDown list to the EntityDataSoucre control I get an error message that read as follows

Quote:
The Schema could not be determined because of the following error from the EntityDataSource:

The underlying provider failed on Open.
Inner exception: Cannot open user default database. Login failed.
Login failed for user ‘NONE-E81F1BF7DC\MyUsername
What happened here everything was working fine just a minute ago at a loss here.

Some thoughts do I need to registar my version of SQL Express? (I do not think I am over the 30 day limit also I can long into the database using SQL Managenment Studio no problem and I also noticed there seems to be a probelm with the enity database in SQL itself no access to any of the tables it is like it knows that the database is there but can not see it. In my database Exploer window i can see it just fine and cann access all the tables. When i try to run one of my other pages that where working before like the all photos album i get the same exception in the brower window do you have any clue what I need to do here?
 
Old March 9th, 2012, 12:21 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

Quote:
What happened here everything was working fine just a minute ago at a loss here.
Do you still have this problem? It's odd that you can see the tables but run into this error when you try to use the EF designer. is NONE-E81F1BF7DC\MyUsername the actual account you use to log in to Windows?

Also, did you attach the database to SQL Server or are you running it from App_Data?

Quote:
I do not think I am over the 30 day limit also I can long into the database using SQL Managenment Studio no problem
Which 30 days are you talking about? SQL Express is free and should never expire.

Quote:
it is like it knows that the database is there but can not see it.
Have you tried running SQL Server Management Studio as an Administrator? (Right-click and choose Run As Administrator).

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old March 11th, 2012, 04:30 PM
Authorized User
Points: 134, Level: 2
Points: 134, Level: 2 Points: 134, Level: 2 Points: 134, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 22
Thanks: 0
Thanked 4 Times in 4 Posts
Default

So I am taking out time from my busy schedule to let everyone know what happened.

I never did get that database to work again. I ended up deleting it altogether.

Then I went to my App_Data folder and right clicked on it and choose add existing item.

I then added my Database from the downloaded location on my E: drive same is my Data connection.

Then I went back and redid all the database connections from chapter 14 and 15.

That made it work and now I have only one data base and not two identical ones.

From what I can tell the problem came from the earlier try it out Handling Errors when Deleting Rows. When I followed the instructions as laid out in there and went to delete a row that had a connections to reviews I got the red error message but is some how corrupted my database and also never closed the connection made to it. So given the license restrictions I believe in SQL express, you can only have one connection open at a time, I could not reconnect to the database to see what happened.
 
Old March 12th, 2012, 03:19 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Quote:
So given the license restrictions I believe in SQL express, you can only have one connection open at a time,
That shouldn't be the case. Restrictions for SQL Express revolve around database size and hardware support, and as far as I know, you can have asnmany connections open to the same server as you want (many of my production sites share the same SQL Server Express instance).

It seems something somehow got courrupted, but it's hard to tell what....

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!




Similar Threads
Thread Thread Starter Forum Replies Last Post
chapter 15 - ciwluke BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 July 11th, 2008 03:33 PM
chapter 15 help kyledonmoyer BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 2 June 30th, 2007 08:06 AM
Chapter 15 rrlevron BOOK: Beginning ASP 3.0 0 November 17th, 2005 03:38 PM
Chapter 15 moggie BOOK: Beginning ASP 3.0 2 October 19th, 2004 01:30 PM
Chapter 15 help Lorenzo_G BOOK: Beginning ASP 3.0 1 November 27th, 2003 01:00 PM





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