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 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8
This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 by Chris Hart, John Kauffman, David Sussman, Chris Ullman; ISBN: 9780764588501
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 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
  #11 (permalink)  
Old May 14th, 2006, 09:43 AM
Registered User
 
Join Date: May 2006
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok, what would we do without you Imar :-).
I'll install the express version as well.

/Lars

  #12 (permalink)  
Old May 25th, 2006, 08:47 PM
Authorized User
 
Join Date: Dec 2004
Location: , , USA.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bettyb1656
Default

I have been trying (and failing) to get WroxUnited to work with 2005 developer edition. I suppose I could take your advice and install 2005 express to get WroxUnited to work, but how would this help me to learn what is needed to connect to the real 2005 database? So far I find nothing in the "Beginning ASP.NET 2.0" book that helps with the database connection.

--
BettyB.
www.flamingo-code.com
  #13 (permalink)  
Old August 9th, 2006, 06:55 PM
Authorized User
 
Join Date: Aug 2006
Location: Branson, MO, USA.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jim Buchan
Default

Once you're done developing your site with the Express edition, it's pretty easy to move the database to a "real" version of SQL Server....

Everybody says how easy it is to move the database to a "real" version of SQL Server but I just don't get it! How do you do that? Move a SQL Express DB into a SQL 2000 database? When runing aspnet_regsql.exe does that copy the data from the existing appData Folder in to the SQL 2000 tables? What about all of your other custom tables, views, stored procedures,and such? Does it copy them too? If not, how do you get them there? Any help would should be appreciated.

  #14 (permalink)  
Old August 10th, 2006, 12:56 AM
Imar's Avatar
Wrox Author
Points: 71,561, Level: 100
Points: 71,561, Level: 100 Points: 71,561, Level: 100 Points: 71,561, Level: 100
Activity: 20%
Activity: 20% Activity: 20% Activity: 20%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,002
Thanks: 79
Thanked 1,574 Times in 1,551 Posts
Default

Well, I never said it's easy to move a SQL Server Express 2005 database to a 2000 environment. In fact, that's impossible....

However, it's easy to move a 2005 Express database to another 2005 installation. Simply copy the .MDF file and attach it to the new server.

aspnet_regsql.exe doesn't do anything with data or your database objects. All it does is create a bunch of objects required for ASP.NET like the aspnet_* tables, views and so on. It doesn't touch your database, or copy your data at all.

Take a look at this article to learn more about SQL Server 2005, how to attach a database and how to configure the database and your application so the two can work together.

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

Re: moving a 2005 to 2000: it depends on a number of factors if you can do this at all. If you're using SQL Server specific features (like the new CTP syntax feature), you're pretty much out of luck. Otherwise, you can script your database using "SQL Server Management Studio" (not sure, but the SQL Server Management Studio Express Edition may support this as well) and then run this script on your SQL 2000 database.

You just need to be aware of the differences between 2000 and 2005. I think in general, it's easiest if you develop on the platform that you intend to use for production as well. Developing against 2005, while deploying on 2000 is likely to get you into problems, or at least into a lot of work.

Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
  #15 (permalink)  
Old August 10th, 2006, 06:29 AM
Authorized User
 
Join Date: Aug 2006
Location: Branson, MO, USA.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jim Buchan
Default

Thanks Imar, you have answered my question and I appreciate it. I suspected all along that running the exe would only accomplish the db creation with required tables, views, etc. per the switch settings used in its execution and not move any data. Your comment as to developing using the ultimate deployment version of SQL is appropriate and unfortunately a lesson I have learned the hard way. Thanks for your response I very much appreciate your efforts and feedback.

  #16 (permalink)  
Old August 10th, 2006, 11:27 AM
Imar's Avatar
Wrox Author
Points: 71,561, Level: 100
Points: 71,561, Level: 100 Points: 71,561, Level: 100 Points: 71,561, Level: 100
Activity: 20%
Activity: 20% Activity: 20% Activity: 20%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,002
Thanks: 79
Thanked 1,574 Times in 1,551 Posts
Default

You're welcome....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
  #17 (permalink)  
Old August 30th, 2006, 10:39 PM
Registered User
 
Join Date: Jul 2006
Location: Siloam Springs, AR, USA.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hstandley
Default

I too get this message:

The user instance login flag is not supported on this version of SQL Server. The connection will be closed.

I am using sql2005, not express. Can some explain to me what themessage means and whether a clear explaination is out there.

Thanks,
Harry

Harry Standley
  #18 (permalink)  
Old August 31st, 2006, 02:11 AM
Imar's Avatar
Wrox Author
Points: 71,561, Level: 100
Points: 71,561, Level: 100 Points: 71,561, Level: 100 Points: 71,561, Level: 100
Activity: 20%
Activity: 20% Activity: 20% Activity: 20%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,002
Thanks: 79
Thanked 1,574 Times in 1,551 Posts
Default

The answer is in the previous posts in this thread. You need to remove User Instance=True from your connection string as that only applies to SQL Server Express 2005.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
  #19 (permalink)  
Old September 5th, 2006, 08:31 PM
Registered User
 
Join Date: Jul 2006
Location: Siloam Springs, AR, USA.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hstandley
Default

OK I really appreciate your patience. I installed sql express as suggested earlier, same error, removed the user instance and still I get the same error message. Sorry but I am totally lost on this example in the book.

Harry

Harry Standley
  #20 (permalink)  
Old September 8th, 2006, 09:13 PM
Registered User
 
Join Date: Oct 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry,test .

 


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
Learn Professional ASP.NET using VS2005 Express glam ASP.NET 2.0 Professional 0 December 1st, 2005 05:19 PM
Can'T find code to Beginning Asp.net using VB.NET darruler All Other Wrox Books 1 August 12th, 2004 05:04 PM
Help 'beginning asp.net using vb.net' source code jkmf Wrox Book Feedback 1 January 18th, 2004 07:09 AM
Beginning ASP.Net Databases Using VB.Net ISBN 6195 tlamazares SQL Server ASP 1 December 15th, 2003 12:28 PM



All times are GMT -4. The time now is 11:28 AM.


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