Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Basics
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 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 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.
  #12 (permalink)  
Old January 5th, 2010, 04:21 PM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,038
Thanks: 80
Thanked 1,580 Times in 1,557 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)
  #13 (permalink)  
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.
  #14 (permalink)  
Old January 5th, 2010, 06:10 PM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,038
Thanks: 80
Thanked 1,580 Times in 1,557 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)
  #15 (permalink)  
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.
  #16 (permalink)  
Old January 5th, 2010, 06:36 PM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,038
Thanks: 80
Thanked 1,580 Times in 1,557 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)
  #17 (permalink)  
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
  #18 (permalink)  
Old January 5th, 2010, 07:24 PM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,038
Thanks: 80
Thanked 1,580 Times in 1,557 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)
  #19 (permalink)  
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
  #20 (permalink)  
Old January 9th, 2010, 07:11 AM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,038
Thanks: 80
Thanked 1,580 Times in 1,557 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)
 


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
deployment Bhavin Crystal Reports 1 February 5th, 2009 08:07 AM
deployment p2pMember ASP.NET 2.0 Basics 0 June 7th, 2007 02:12 AM
Deployment sen22 .NET Framework 2.0 1 April 17th, 2007 03:38 PM
Deployment regbnvl BOOK: Professional VB 2005 ISBN: 0-7645-7536-8 0 May 7th, 2006 05:44 PM
Deployment Bhavin Crystal Reports 2 October 25th, 2004 09:28 AM



All times are GMT -4. The time now is 06:29 PM.


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