Wrox Programmer Forums
|
ASP.NET 3.5 Basics If you are new to ASP or ASP.NET programming with version 3.5, this is the forum to begin asking questions. Please also see the Visual Web Developer 2008 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 3.5 Basics 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 January 5th, 2010, 03:15 PM
Authorized User
 
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by Imar View Post
Hard to tell as I don't know what services they offer and at what quality. Not allowing scripts is not uncommon.

How were you able to create the tables? Did you use Management Studio? If so, you can use it to transfer data as well.

Imar
Imar,

They told me the scripts weren't allowed so what I had to do was export the schemas only in sql management studio and then create the tables from those. Following that, I managed to do the same with the data.

Unfortunately, some of the data had <p> <b> and other html, so that didn't. So all I need to do now is add those records back, only a couple of hours work and then all my book reviews and health recipes will be there for the world to enjoy.

You can check the site now, using your book I've managed to configure the connection strings and everything is good to go.

I think if my host had been more clear and offered the advice I needed, then it could have all been sorted a lot quicker.

But yeah. I'm live and you can check me out at www.ntcoding.com. Book reviews and recipes to be added over the next few hours.

Thanks.
 
Old January 5th, 2010, 04:21 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Yeah, I noticed it was up and running when I posted my last message. Great to see the site progress each time I check... ;-)

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!
The Following User Says Thank You to Imar For This Useful Post:
NickTUK (January 5th, 2010)
 
Old January 5th, 2010, 06:06 PM
Authorized User
 
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by Imar View Post
Yeah, I noticed it was up and running when I posted my last message. Great to see the site progress each time I check... ;-)

Imar
Almost, almost there. I managed to get all my old database entries back by snipping out all the html. So now all I need to do is login to the management section and add them back.

However, that's where I've come unstuck. Once this is sorted, I am fully up and running. Here's the problem:

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

I've run aspnet_regsql on the database and re-uploaded all the tables that were originally from the ASPNETDB database. I've then followed the instructions on Appendix B to set up the providers on web.config and to override the LocalSqlServer.

If this something that is really obvious, please can you let me know? In the meantime I'm going to check all the connection string details and providers for typos.

Thanks.
 
Old January 5th, 2010, 06:10 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Quote:
If this something that is really obvious, please can you let me know?
The error message says that stored procedures (and Views) for the Application Services (Memberhip, Roles and Profile) are missing. Copying tables is not enough; you also need to copy the many Views and Stored Procedures from the aspnetdb database, either through Management Studio or by using aspnet_regsql as explained in Appendix B (if your hosts allows remote access).

I am still not sure how exactly you're creating your tables, so I can't really recommend the best way to copy these objects.

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!
The Following User Says Thank You to Imar For This Useful Post:
NickTUK (January 5th, 2010)
 
Old January 5th, 2010, 06:30 PM
Authorized User
 
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by Imar View Post
The error message says that stored procedures (and Views) for the Application Services (Memberhip, Roles and Profile) are missing. Copying tables is not enough; you also need to copy the many Views and Stored Procedures from the aspnetdb database, either through Management Studio or by using aspnet_regsql as explained in Appendix B (if your hosts allows remote access).

I am still not sure how exactly you're creating your tables, so I can't really recommend the best way to copy these objects.

Imar
Hi Again Imar,

I solved this issue.

When I checked the stored procedures list they weren't actually there. So I did a publish from VWD of the schema only and this worked perfectly. But it also reset my data.

So then I published the data only and that worked fine.

It makes me laugh really. The combined schema and data publish did not work, but individually they do.

Wow. I thought the uploading was going to be the easy bit! But I'm finally there. Thanks for all your help (including the book).

The review of your book and all the other records on my site will be re-formatted with html tags so you can view them as intended if you wish.

Thanks again for all your help.
 
Old January 5th, 2010, 06:36 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Are you automatically generating the cover images? This results in some awkward images / reviews as the images are cached. Also, since each review seems to be using the same physical image (http://www.ntcoding.co.uk/Images/Boo...eviewImage.jpg, or so it appaers), concurrent visits will get you in trouble....

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!
The Following User Says Thank You to Imar For This Useful Post:
NickTUK (January 5th, 2010)
 
Old January 5th, 2010, 07:06 PM
Authorized User
 
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by Imar View Post
Are you automatically generating the cover images? This results in some awkward images / reviews as the images are cached. Also, since each review seems to be using the same physical image (http://www.ntcoding.co.uk/Images/Boo...eviewImage.jpg, or so it appaers), concurrent visits will get you in trouble....

Imar
Yeah, as the images are read into the individual review page it is resized and saved as BookReviewImage.jpg.

Concurrency wasn't something I anticipated, but I can definitely see the drawbacks with this approach.

I did check all the reviews on my home set up. My plan was to check them out at work on the large screen monitors when I get chance.

The book images I did want to switch for better quality ones before I started showing my site to prospective employers, though.

If you spot anything else then please send the comments this way.

Cheers

Nick
 
Old January 5th, 2010, 07:24 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 probably want to save / stream them as:

BookReviewImageReviewId.jpg

instead so each review gets its own image. Because the browser caches this file, you only ever see the image from the first review you view, for all subsequent reviews you visit.

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!
The Following User Says Thank You to Imar For This Useful Post:
NickTUK (January 6th, 2010)
 
Old January 8th, 2010, 08:28 AM
Authorized User
 
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
Default

Cross browser and cross monitory compaitibility is proving to be quite fun. But I should be able to resolve all those issues quite soon.

One problem I am facing is sending emails. From local host it works fine, but when the site goes live, I get and error about connections involving a time out.

After a bit of research, it seems to be an authentication/proxy issue. I've got a few articles to read which may yield an answer, but if anyone knows what the problem will be it would save me a bit of time and be appreciated.

thanks
 
Old January 9th, 2010, 07:11 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

How did you configure the mail server? And did you get the relevant details from your host? Just as with databases, your host should be able to provide you with details about sending mail. They may give you access to a (password potected) mail server, or they may provide other information about how to make this work.

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!
The Following User Says Thank You to Imar For This Useful Post:
NickTUK (January 9th, 2010)





Similar Threads
Thread Thread Starter Forum Replies Last Post
deployment Bhavin Crystal Reports 1 February 5th, 2009 08:07 AM
deployment p2pMember ASP.NET 2.0 Basics 0 June 7th, 2007 01:12 AM
Deployment sen22 .NET Framework 2.0 1 April 17th, 2007 02:38 PM
Deployment regbnvl BOOK: Professional VB 2005 ISBN: 0-7645-7536-8 0 May 7th, 2006 04:44 PM
Deployment Bhavin Crystal Reports 2 October 25th, 2004 08:28 AM





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