p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 (http://p2p.wrox.com/forumdisplay.php?f=389)
-   -   Chapter 11 (http://p2p.wrox.com/showthread.php?t=68534)

Moorish June 2nd, 2008 09:55 AM

Chapter 11
 
I am at page Chapter 11 page 356 When I drag the Planetwrox mdf to the App_Data folder it does not connect to the SQL database. I am using Visual developer 2008. COULD SOMEONE WALK ME THRU THE DATABASE SETUP. Or can assist me with this problem.:(

Darnell

Imar June 2nd, 2008 10:28 AM

Hi Darnell,

What version of SQL server are you using? Did you install SqlExpress at (local)\SqlExpress as explained in the first chapter of the book?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Moorish June 2nd, 2008 01:04 PM

I am using the SQL server 2005 that came with Visual Studio 2008
I am running the SQLexpress local onm machine Microsoft SQL 2005 but we I try to drag and drop the databases it does not work, I really appreciate your help because I really need to finish the book This is the first snag I've had. I think I installed SQLExpress directly from the CD that came with VWD pro

Darnell

Moorish June 2nd, 2008 01:12 PM

---------------------------
Microsoft Visual Studio
---------------------------
The file "C:\BegASPNET\Resources\Chapter 11\PlanetWrox.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

Could not open new database 'C:\BEGASPNET\RESOURCES\CHAPTER 11\PLANETWROX.MDF'. CREATE DATABASE is aborted.

An attempt to attach an auto-named database for file C:\BegASPNET\Resources\Chapter 11\PlanetWrox.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
---------------------------
OK
---------------------------


Darnell

Moorish June 2nd, 2008 01:13 PM

????
The file is decompressed

Darnell

Imar June 2nd, 2008 04:09 PM

Judging by the error message, it seems that you didn't create the database inside the App_Data folder, as instructed by the book.

Make sure you add it to App_Data through the Solution Explorer, or drag an existing MDF file from Windows Explorer into the App_Data folder (that you need to create using the Solution Explorer).

How are you dragging the file? It should create a copy when you drag it from the Resources folder into VWD, so you shouldn't get this error message. Or are you maybe dragging the file directly from the ZIP file without extracting the files first as explained at the beginning of the book?

Hope this helps,

Imar



---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Moorish June 3rd, 2008 06:51 AM

I did everything you said still get same error

Darnell

Imar June 3rd, 2008 07:04 AM

Hi Darnell,

Can you provide a detailed description of all the steps you are performing? You shouldn't get these errors when you follow the book to the letter, so it looks like something is going wrong somewhere. However, it's hard for me to say where without knowing what it is that you do exactly....

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Moorish June 3rd, 2008 07:37 AM

darnell_albert@yahoo.com
I am desperate, I am willing to give you access to my machine etc. I got to learn this book. It's the best book out there. Please if you have a remote access method or app. email me at darnell_albert@yahoo.com I will give you access. I know we have a time zone difference. However I am will to let you see for yourself I will have Visual studio up etc.
I really appreciate your help
Thanks

Darnell

Imar June 3rd, 2008 07:55 AM

Quote:

quote:It's the best book out there.
I really like these kind of one-liners. Spread the word, spread the word! ;)

Send me an e-mail through my Profile page (just click my name in this thread) and I'll reply. It might take some time before I can take a look though....

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.


All times are GMT -4. The time now is 12:22 PM.

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