Wrox Programmer Forums
|
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3
This is the forum to discuss the Wrox book Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars; ISBN: 9780470187593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 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 April 14th, 2009, 11:42 PM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 11 Sample database Connection Closed

Hi Imar,

Love your book. It's midnight and I won't be able to try your solution until tomorrow evening when I get home from work but I thought I would just post the problem now.

I'm at Chapter 11 where you say to drag the PlanetWrox.mdf and PlanetWrox_log.ldf files from the resources folder into VWD. I did this but when I double click the .mdf file, it brings me to the Database Explorer which shows the database icon with a little red x on it indicating that the connection is closed. The properties window also shows the "State" property as "Closed"

I'm using SQL Server 2005. This is my connection string:
Data Source=.\SQLEXPRESS;AttachDbFilename=C:\TestSite\A pp_Data\PlanetWrox.mdf;Integrated Security=True;User Instance=True

I checked the permissions on the App_Data folder and my windows user account does have modify and all the other permissions on that folder.

Hope I was clear enough in explaining the problem. Thanks and I will respond to your input soon.

San
 
Old April 15th, 2009, 02:31 PM
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,

Does this:

>> I'm using SQL Server 2005

imply the full version of SQL Server? Or do you have a locally installed Express instance called .\SqlExpress?

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 April 15th, 2009, 02:39 PM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It's a locally installed Express Instance.

I installed this some time ago when I had a trial version of VS 2005 and when I start my windows XP machine, I can see that my SQLExpress instance is running in the task bar.
 
Old April 15th, 2009, 02:42 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Task bar = task manager? (Not wanting to nitpick; just interested in where you see it).

Can you connect to the database using SQL Server Management Studio?

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 April 15th, 2009, 03:09 PM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yea, I mean the task bar. Hmm. I didn't try through management studio. I'll try in 2 hours when I get home from work. Hopefully you'll still be online. Should I try anything else if I can't connect through SQL Server management studio?
 
Old April 15th, 2009, 03:13 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

I assume you mean the task *manager*? The task bar is where you see icons for open Windows, a location where you typically don't find SQL Server.

If you can't connect with Management Studio, SQL Server may not be installed correctly. If you're not reyling on it for other databases, an uninstall and a reinstall is probably the quickest way to fix things.

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 April 15th, 2009, 03:18 PM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I meant the task bar because I set my instance of SQL server to start up when windows starts. It is a white barrel icon with a green arrow button that displays in the task bar. It allows me to start and stop my instance of SQL server 2005. I didn't check the task manager to see if its running there.

I'll check, reinstall if it doesn't work and get back to you.

Thanks
 
Old April 15th, 2009, 03:22 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

You mean this one: http://images.google.com/images?hl=e...&gbv=2&aq=f&oq=

That icon was there for SQL Server 2000, right? I've never seen it for 2005....

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 April 15th, 2009, 03:35 PM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, I had SQL Server 2000 installed first, then I installed SQL Server 2005 Express. The icon on the task bar allows me to switch between different instances of SQL Server 2005 express. Maybe I still have the icon from my SQL Server 2000 days but when I check it, the instance that is running is the SQLServerExpress one.
 
Old April 15th, 2009, 03:44 PM
Registered User
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, The link that you sent is exactly what displays in my task bar. Well, it displays as a white barrel with a green arrow on my task bar. When I double click it, a window like the one you sent in the link, pops up allowing me to stop or start the instance or switch to a different instance.

It's hard to believe that they would put that icon in SQL Server 2000 then remove it in 2005. It makes accessing the instance easy.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 11 - Can't connect to database G276 BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 1 February 7th, 2009 04:46 AM
Chapter 11 - Problem Opening Database dbcook8 BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 15 February 2nd, 2009 08:41 AM
Chapter 11 Connection Issue justin000 BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 August 4th, 2008 06:14 AM
Connection Chapter 11?! workidoo BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 July 15th, 2008 04:01 AM
Error in Chapter 11 Sample Code josevi BOOK: Professional SharePoint 2007 Development ISBN: 978-0-470-11756-9 1 February 1st, 2008 01:43 PM





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