 |
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
|
|
|

January 5th, 2010, 03:15 PM
|
Authorized User
|
|
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
|
|
Quote:
Originally Posted by Imar
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.
|

January 5th, 2010, 04:21 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
The Following User Says Thank You to Imar For This Useful Post:
|
|

January 5th, 2010, 06:06 PM
|
Authorized User
|
|
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
|
|
Quote:
Originally Posted by Imar
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.
|

January 5th, 2010, 06:10 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
The Following User Says Thank You to Imar For This Useful Post:
|
|

January 5th, 2010, 06:30 PM
|
Authorized User
|
|
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
|
|
Quote:
Originally Posted by Imar
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.
|

January 5th, 2010, 06:36 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
The Following User Says Thank You to Imar For This Useful Post:
|
|

January 5th, 2010, 07:06 PM
|
Authorized User
|
|
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
|
|
Quote:
Originally Posted by Imar
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
|

January 5th, 2010, 07:24 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
The Following User Says Thank You to Imar For This Useful Post:
|
|

January 8th, 2010, 08:28 AM
|
Authorized User
|
|
Join Date: Oct 2009
Posts: 17
Thanks: 7
Thanked 1 Time in 1 Post
|
|
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
|

January 9th, 2010, 07:11 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
The Following User Says Thank You to Imar For This Useful Post:
|
|
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 |
|
 |