Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 2.0 AJAX ISBN: 978-0-470-11283-0
This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 AJAX by Wallace B. McClure, Paul Glavich, Steve C. Orr, Craig Shoemaker, Steven A. Smith, Jim Zimmerman; ISBN: 9780470112830
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 2.0 AJAX ISBN: 978-0-470-11283-0 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 23rd, 2007, 01:32 PM
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server?

I got as far as page 17 before my learning came to a screeching halt.
Seems that I need SQL Server 2005 in order to use this book. Before buying the book I reviewed the "What You Need to Use this Book" section of the Introduction to confirm that I had everything needed. No Problem. But, when I reached the "Creating a Database to Manage Users and Roles" it failed due to the an in-ablilty to connect to SQL Server. I had SQL Server 2000 installed and have had many years of success using it with VS6, and VS03. I tried using the aspnet_sqlreg.exe utility but it failed to connect as well. Do I need to install SQL Server 2005? If so, then what of the 2000 Servers. Also, which edition, Standard, Developer, or Enterprise (tried this on and only go client stuff). Any help in this would be cool.



seabhacre
  #2 (permalink)  
Old July 24th, 2007, 08:14 AM
Wrox Author
 
Join Date: Jul 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to glav
Default

The aspnet_regsql utility works with 2000 as well and have used it many times on 2000 before. Can you provide more detail around the connection problem you had when using it?

- Glav
  #3 (permalink)  
Old July 24th, 2007, 09:00 AM
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

-glav
Thanks for the reply.

Since my original post I continued to dig, fight, and scrape my way to a solution. Although I found many answers, none worked for my setup. However, I did find a solution and am now (as I type this) into section "Creating a Data Access Layer". My solution:

I upgraded from 2000 to 2005 Dev, needed doing anyway...

I manually created a copy of the ASPNetDB.mdf file in the App_Data folder, Created with aspnet_regsql.exe utility that came with '05 Dev.

I had no problem creating a connection to it in using Server Explorer, but the ASP.Net Configuration tool still failed. This lead me to verify all connection strings.

I discovered that the Configuration tool used the CS from machine.config so I changed the connection strings data source = localhost.

This didn't work but I did get a different error message which helped track down a small tidbit on MSDN that stated that the User Instance setting in the machine.config connection string, when set to true, caused the SQLConnectionHelper to treat the data source as SQLEXPRESS no matter what it is set to in the data source parameter.

I changed the User Interface parameter to false, and Walla Walla, it worked.

Thanks again and wish me luck with the rest of the book...

 -- SeabhacRe



seabhacre
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 04:34 AM
SQL Server Reg. SQL Server does not exist error Arsi SQL Server 2000 1 June 11th, 2008 12:20 PM
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM
SQL Server sync with net server and browser server ne SQL Server DTS 0 June 13th, 2005 07:29 PM
SQL Server 7.0 talking to SQL Server 2000 msavage SQL Server 2000 1 August 20th, 2003 02:59 AM



All times are GMT -4. The time now is 03:38 AM.


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