Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 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 October 4th, 2008, 05:47 PM
Registered User
 
Join Date: Oct 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Hosting on GoDaddy.com

I got the Beerhouse program to work locally. I then created a script of the database using SQL server database publishing wizard. I executed the script on Godaddy.com (no error messages). I fixed my connection string to:
<connectionStrings>
    <remove name="LocalSqlServer"/>
     <add name="LocalsqlServer" connectionString="
                Server=p3swhsql-v06.shr.phx3.secureserver.net;
        Database=xxxxx;
                User ID=xxxxx;
                Password=xxxxx;
                Trusted_Connection=False" providerName="Syste m.Data.SqlClient" />

    
</connectionStrings>

Now I am getting the following error: http://BertelsenWinery.com (click on the link to see the error message).

Anyone have any idea why I am getting this error? Anyone have any luck hosting the Beerhouse on Godaddy.com?

Thanks,
Photon
 
Old October 4th, 2008, 11:30 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Google is an amazing tool.

http://www.google.com/search?q=The%2...UTF-8&oe=UTF-8

Second hit:

http://www.codeverge.net/ng.asp-net-...hema-version-1
 
Old October 5th, 2008, 08:39 AM
Registered User
 
Join Date: Oct 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your reply but I still haven't been able to resolve my problem.

The link that was provided suggested the following:
1)I simply logged onto my SQL Server production machine (I can do that since I own the machines)
2)I ran the aspnet_regsql GUI and logged on as "sa"
3)Then I installed the aspnetdb tables into my database

However, I am using Godaddy.com and I don't have access to aspnet_regsql GUI. I have to create my database using scripts. No other options that I am aware of.

Is there anything else I can do?
Thanks,
Photon
 
Old October 5th, 2008, 10:37 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Quote:
quote:I then created a script of the database using SQL server database publishing wizard.
Did you only create the schema?

The .NET providers need some base data in the tables in order to operate successfully. So, you need to script schema and data using the Database Publishing Wizard.

Hope this helps

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old October 5th, 2008, 02:38 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

The writer that you (Photon, that is) quoted said he did it that way because he *DID* have access to the server. But two other sites were referenced, and at least one of them doesn't assume such access. But he also said "the suggestion from the guy in the Beer House project worked!" Did you follow that link??
http://www.codeplex.com/TheBeerHouse...orkItemId=4252
 
Old October 5th, 2008, 04:19 PM
Registered User
 
Join Date: Oct 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Imar,

That was the solution. For some reason Sql database publishing wizard made a huge data script (3.5 megabytes). godaddy wouldn't upload that big a script, so I copied and pasted sections of the script at a time. And now things are working.

Thanks again,
Photon
 
Old October 5th, 2008, 04:55 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

For future reference: If you use an FTP client, you can upload file much much larger than only 3.5MB to GoDaddy. I needed to transfer a 150MB file from work to home a while back, and I did it by uploading via FTP to my GoDaddy account and downloading via FTP when I got home.

GoDaddy's HTTP uploader is, as you noticed, quite limited. But FTP is an entirely different transfer protocol.
 
Old October 6th, 2008, 01:53 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Photon,

You're welcome. Glad it's working now....

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old October 6th, 2008, 08:18 AM
Registered User
 
Join Date: Oct 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Old Pedant,

I will remember that FTP tip.

Photon





Similar Threads
Thread Thread Starter Forum Replies Last Post
hosting asp to go Forum and Wrox.com Feedback 0 April 8th, 2008 01:38 PM
cannot load the sql file to Godaddy Server EswaraPrakash BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 0 August 16th, 2007 04:08 PM
Any hosting site... rupen Classic ASP Basics 3 April 3rd, 2007 04:34 AM
GoDaddy script install problems robhmac Perl 3 October 24th, 2006 07:39 AM
Hosting mani_he PHP Databases 4 December 14th, 2004 02:27 PM





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