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

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

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

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.

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

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

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.

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.

Thanks Old Pedant,

I will remember that FTP tip.

Photon