 |
| 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
|
|
|
|
October 21st, 2013, 03:10 AM
|
|
Registered User
|
|
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
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..
|
|
October 21st, 2013, 06:50 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
The Following User Says Thank You to Imar For This Useful Post:
|
|
|
October 21st, 2013, 01:03 PM
|
|
Registered User
|
|
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
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
|
|
October 21st, 2013, 02:16 PM
|
|
Registered User
|
|
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
after reinstall
Nope, unfortuantely its still having the same issue after a re-install  , darn.
- Clay
|
|
October 21st, 2013, 02:31 PM
|
|
Registered User
|
|
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
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.
|
|
October 21st, 2013, 02:59 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
>> 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
|
|
The Following User Says Thank You to Imar For This Useful Post:
|
|
|
October 21st, 2013, 03:32 PM
|
|
Registered User
|
|
Join Date: Oct 2013
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
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
|
|
October 21st, 2013, 03:41 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
>> (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
|
|
The Following User Says Thank You to Imar For This Useful Post:
|
|
|
|
button below this post to show your appreciation!
