Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4.5 > ASP.NET 4.5 General Discussion
|
ASP.NET 4.5 General Discussion For ASP.NET 4.5 discussions not relating to a specific Wrox book
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 4.5 General Discussion 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 October 21st, 2013, 03:10 AM
Registered User
 
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
Unhappy database problems, drag and drop and auto renaming mdf file

Hello,

I'm just beginning to use Visual Studio Express for Web 2012, have used he 2012 version and have successfully completed both wrox beginner books for the aspnet 4 and 4.5 framework in VB. I have a few issues.

First, I am unable to drag and drop a table from Database Explorer to page for some reason, the page is in design view and everything it just doesn't do anything.

Second, any attempt to create a connection string, either manually or auto generated with a SQLDataSource control, changes the name of my database in Database Explorer to whatever the connection string name is?!

Another issue that concerns me is when I try to refresh the data connection I often times get an error message window entitled "Server Explorer Error" and the message says - Server Explorer is unable to perform operation. See below for details: (below says) Cannot open database "aspnet-killdozerproductions-20131021015112" (I recognize the name of folder 'killdozerproductions' but I have no idea what the number references) requested by the login. The login failed. Login failed for user 'ClayOffice-PC\ClayOffice' (pc name/user name).

Please advise, thank you so much.

- Clay

Last edited by kadencole; October 21st, 2013 at 03:15 AM..
 
Old October 21st, 2013, 06:50 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

The number in the database more or less represents the date and time the database was created. VS creates a database with a unique name when you use membership and haven't manually pointed the application services to your own database.

I don't know what's going on with the other issues. Can you provide a bit more background? Which database do you use and where is it located? Are you using SQL Server Local DB?

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!
The Following User Says Thank You to Imar For This Useful Post:
kadencole (October 21st, 2013)
 
Old October 21st, 2013, 01:03 PM
Registered User
 
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
Default more info

Thanks for a quick response, sure, this is a database for a custom site its called something like kdpWeb.mdf and I created it in SQL management studio in localdb/v11.0 under Databases matching what I learned in the book and placing it in the App_Data path of the website (located off my c drive), so yes I would be using SQL server express and localdb - btw, I'm going to uninstall and re-install this afternoon so I'll post back if the problem persists. If you have any thoughts please let me know, thanks! Cheers.
- Clay
 
Old October 21st, 2013, 02:16 PM
Registered User
 
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
Default after reinstall

Nope, unfortuantely its still having the same issue after a re-install, darn.
- Clay
 
Old October 21st, 2013, 02:31 PM
Registered User
 
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
Default another followup

Here's an interesting side note, the laptop I used to go through the book (beginning aspnet 4.5) which was completely fine for the book WILL allow me to drag and drop tables in design view to the page, however, still renames the database in the database explorer to whatever the connection string name is.
 
Old October 21st, 2013, 02:59 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

>> however, still renames the database in the database explorer to whatever the connection string name is.

Not 100% sure what you're describing, but isn't this just by design? That is, the Database Explorer shows connections it can find in web.config.

Have you tried running VS / VWD as an administrator to see if that fixes the drag/drop issue?

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!
The Following User Says Thank You to Imar For This Useful Post:
kadencole (October 21st, 2013)
 
Old October 21st, 2013, 03:32 PM
Registered User
 
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
Default running as admin

I did try running as admin, the drag and drop feature is still not functioning (I really liked that feature) but as far as the Database Explorer issue - yeah, maybe I making much ado over nothing, I checked back at my BegAspnet site project from the book and I guess I just never noticed the Database Explorer window displaying a connection string as opposed to the database file name, (did it do that in visual web developer express 2010?) anyway, so I guess I should just get used to that. I also noticed from the book files there is an EntityFrameWork.dll in the bin, I currently do NOT have one in my site, is that something that will generate when I create an entity model or do I need to install that through NuGet or some other fashion, thanks so much for your help!
- Clay
 
Old October 21st, 2013, 03:41 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

>> (did it do that in visual web developer express 2010

This could be the different between SQL Server Express and Local DB

>> is that something that will generate when I create an entity model or do I need to install that through NuGet or some other fashion

Yes, if you add an entity model, this will also configure EF. You could also add the package using NuGet.

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!
The Following User Says Thank You to Imar For This Useful Post:
kadencole (October 21st, 2013)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Single database for ASPNETDB.mdf and database.mdf grouchy ASP.NET 4 General Discussion 9 August 29th, 2011 05:40 PM
can't open aspnet.mdf database file moulot BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio 1 October 11th, 2009 07:00 AM
how to open database file of .mdf extension ravi.gurgaon BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 August 19th, 2006 05:09 AM
Connecting to project MDF SQL Database File nsoivan Crystal Reports 0 July 31st, 2006 05:14 AM
Drop&Drag file activex ResDev Classic ASP Components 0 January 30th, 2004 09:03 AM





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