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

You are currently viewing the BOOK: Beginning ASP.NET 4.5 : 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 January 29th, 2014, 07:36 PM
Authorized User
Points: 416, Level: 7
Points: 416, Level: 7 Points: 416, Level: 7 Points: 416, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 84
Thanks: 29
Thanked 2 Times in 2 Posts
Default Ch 13 Database permissions and access issues

Hi Imar,

Only 6 chapters to go and it's still a great book, Imar. Thanks for your attention to detail and they way you slowly introduce so many different ways to use the IDE. Ch 12 -13 went fine, long but fine. And a few questions...

I thought I would make this post because I think I made a mistake that others might make, and also wanted to confirm with you about one aspect of the way Visual Studio and SQL were interacting.

Long story short, Visual Studio initially couldn't open the database I created in SQL Server Management System (SSMS). I have since gone back and researched your text - during the SQL connect splash panel I connected to <user>\SQLEXPRESS, not (LocalDB)\v11.0.

I was able to right click the mdf > Properties > Security and add my user account. But it still didn't work until I deleted the log file. Now, every time I switch back and forth between Visual Studio and SSMS I have to delete the log file.

Will that problem go away if I recreate the database connecting to (LocalDB)\v11.0 or do you think I have something else going on?

Thanks.

Best Regards,
Alan
 
Old January 30th, 2014, 04:54 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

Did you attach the database to SQL Express? That might explain why it gets locked.

Any reason you didn't use LocalDB?

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 January 30th, 2014, 06:04 PM
Authorized User
Points: 416, Level: 7
Points: 416, Level: 7 Points: 416, Level: 7 Points: 416, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 84
Thanks: 29
Thanked 2 Times in 2 Posts
Default

I'm not an SQL guru, so I didn't understand there might be a difference between the 2 connections. Careless. Live and learn.

Yes, I attached to SQLEXPRESS. I've since found out I need to take the database offline in SQL when I'm finished working there, and I still need to delete the log file for some reason. I guess neither program wants to add on to the log the other created or something.

As you might tell from my string of posts, I'm reading your book very seriously, I make sure not a single line of code goes by that I don't understand fully (OK, maybe 1 or 2 slip through...) But really, the point for me is to learn ASP.NET so I can put up my startup's website not using one of the 'boiler plate' site generators. I will eventually need to do a lot of different things and it's clear to me that ASP.NET is the way to go. So it's really intense getting through the book.

All of that is to say I didn't want to take the time right now to go back and re-create the database using the LocalDB. But I will eventually because I have to learn this stuff.

Imar, this is one of the best teaching books I've ever read. Although it is my general practice to seldom comment about products on Amazon, I will make a positive post on Amazon for your book. I will wait until after I finish just to make sure my post is complete and accurate.

If I ever need to learn something in the future that you write about I won't think twice about it, I'll buy your book before anyone else's. Again, thanks kindly for your good work.

Best Regards,
Alan




Similar Threads
Thread Thread Starter Forum Replies Last Post
Ch 13-cms_articles_compose nuhbutt BOOK: Beginning PHP 6, Apache, MySQL 6 Web Development ISBN: 9780470391143 1 June 1st, 2010 12:28 PM
Search ch 13, ch 16 sporik BOOK: Beginning PHP 6, Apache, MySQL 6 Web Development ISBN: 9780470391143 0 October 27th, 2009 04:44 PM
Access issues with ASP and a MS Access Database rj_conceptsnrec.com Classic ASP Databases 2 May 19th, 2005 12:44 PM
Issues Connecting to an Access 2000 Database... Jonny ADO.NET 1 February 11th, 2004 09:54 AM
Authentication and permissions (ch. 5) jangul BOOK: ASP.NET Website Programming Problem-Design-Solution 3 January 19th, 2004 06:32 PM





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