p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 (http://p2p.wrox.com/forumdisplay.php?f=264)
-   -   Hosting on GoDaddy.com (http://p2p.wrox.com/showthread.php?t=70878)

photon October 4th, 2008 05:47 PM

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 Pedant October 4th, 2008 11:30 PM

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

photon October 5th, 2008 08:39 AM

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

Imar October 5th, 2008 10:37 AM

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 Pedant October 5th, 2008 02:38 PM

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

photon October 5th, 2008 04:19 PM

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 Pedant October 5th, 2008 04:55 PM

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.

Imar October 6th, 2008 01:53 AM

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.

photon October 6th, 2008 08:18 AM

Thanks Old Pedant,

I will remember that FTP tip.

Photon


All times are GMT -4. The time now is 12:30 AM.

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