Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 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 Search this Thread Display Modes
  #1 (permalink)  
Old October 4th, 2008, 05:47 PM
Registered User
 
Join Date: Oct 2008
Location: , , .
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
  #2 (permalink)  
Old October 4th, 2008, 11:30 PM
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
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
  #3 (permalink)  
Old October 5th, 2008, 08:39 AM
Registered User
 
Join Date: Oct 2008
Location: , , .
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
  #4 (permalink)  
Old October 5th, 2008, 10:37 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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.
  #5 (permalink)  
Old October 5th, 2008, 02:38 PM
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
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
  #6 (permalink)  
Old October 5th, 2008, 04:19 PM
Registered User
 
Join Date: Oct 2008
Location: , , .
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
  #7 (permalink)  
Old October 5th, 2008, 04:55 PM
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
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.
  #8 (permalink)  
Old October 6th, 2008, 01:53 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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.
  #9 (permalink)  
Old October 6th, 2008, 08:18 AM
Registered User
 
Join Date: Oct 2008
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Old Pedant,

I will remember that FTP tip.

Photon
 


Thread Tools Search this Thread
Search this Thread:

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



All times are GMT -4. The time now is 10:46 PM.


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