Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4 > BOOK: Beginning ASP.NET 4 : in C# and VB
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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?
Reply With Quote
  #2 (permalink)  
Old March 9th, 2012, 12:21 PM
Imar's Avatar
Wrox Author
Points: 72,045, Level: 100
Points: 72,045, Level: 100 Points: 72,045, Level: 100 Points: 72,045, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,083
Thanks: 80
Thanked 1,587 Times in 1,563 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!
Reply With Quote
  #3 (permalink)  
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.
Reply With Quote
  #4 (permalink)  
Old March 12th, 2012, 03:19 AM
Imar's Avatar
Wrox Author
Points: 72,045, Level: 100
Points: 72,045, Level: 100 Points: 72,045, Level: 100 Points: 72,045, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,083
Thanks: 80
Thanked 1,587 Times in 1,563 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!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 03:14 PM.


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