Shortcuts

I need Help Getting publishing my website.

I am new at using Visual Web Developer Express (C#). I understand how to create a website and to test it on my local computer, but I am having trouble understanding what is needed for to publish to website.

1. I have a test website called www.weddingdayplanner.net that I am using to test my VWD website. It is being hosted by
www.1and1.net . I it a business package with one SQL database included. The business package supports ASP.NET 2 but does not offer direct support for VWD Expresses templates (Personal or Club, etc...). My first question
is? Can I use www.1and1.net to publish my VWD website or should I look for a provider that offers direct support for VWD templates?

2. I have uploaded my webpages to the
www.weddingdayplanner.net for testing, and I have uploaded the aspnetdb.mdf to the db_database folder. I get the following error message.

Re: I need Help Getting publishing my website.

Thanks for replying. When I type in
www.weddingdayplanner.net the only error message is see is the one above. However, I did notice that it was showing my user name and password. I have changed the web.config file to prevent it from showing.

<b> Description: </b>An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed
by browsers running on the local server machine.
<br><br>

<b>Details:</b> To enable the details of this specific error message to be viewable on remote machines, please create a &lt;customErrors&gt; tag within a &quot;web.config&quot; configuration file located in the root directory of the current web
application. This &lt;customErrors&gt; tag should then have its &quot;mode&quot; attribute set to &quot;Off&quot;.<br><br>

<b>Notes:</b> The current error page you are seeing can be replaced by a custom error page by modifying the &quot;defaultRedirect&quot; attribute of the application's &lt;customErrors&gt; configuration tag to point to a custom error page URL.<br><br>

Re: I need Help publishing my website.

Thanks for the reply. I have changed the CustomErrors to Off. For testing I am using my local computer with SQL Express running. For Publishing I am using a server that
www.1and1.com has setup for MS web hosting. I am not sure what a virtual directory or version of framework is?

Let me back track for a second. I am wanting to set up a personal website using MS VWD Express. My main interest in having the ability to create user accounts and set roles. I have created a website that works fine on the local computer. I have several
accounts with www.1and1.com using simple html pages for publishing. The account that I am using for testing is a business account that supports 2 SQL Databases and asp.net version 2.0.

What I am not sure of is that I can even set up users account with password access and roles on the
www.1and1.com account. Their tech support is conflicting and lacking good assistance at best.

What I do know is that I have to change the web.config file to have it point to the SQL database on
www.1and1.com server.

I have to upload the database to the SQL Server as a BAK file. Not sure how to do this.

I might have to inter information into the SQL database. Not sure what.

Re: I need Help publishing my website.

I'm not familiar with 1 and 1, but most web hosts have SQL Server 2005 and not Express. You need to run aspnet_regsql.exe to use the membership database on standard SQL, that may not be possible on your host. Uploading existing data depens on the tools
provided by your host. You may be able to upload the database file and attach it, do a backup/restore or even control their database directly with Enterprise Manager. Those are options you need to talk to 1 and 1 about.

Re: I need Help publishing my website.

Tech support from www.1and1.net in the form of any scripting is non-existant. At this point I am looking at hiring an expert in ASP.NET to assist me in getting my website up and running. I believe that I need to see
how it is done by someone else in order to understand the publishing aspect of ASP.NET.

Can I pay you to help me or do you know of someone who is qualified to assist me in setting up my site?

Here are the issues. We can't use the root directory, so there has to be a "redirector" in the root dir. (email and I will send you mine, or any of the code I have tried). Then, the webpage code has to be published to a sub-folder.

Next, we cant do "remote access", so we cant run reg-sql (1and1 support promises that we cant, and they are correct).

To demonstrate that the Database works, they suggest that we go into their admin tools and create a DB Table called "Products" with and "id" and a "price". Then they give the following .ASP to test: (and it works fine) where AAA, BBB, CCC, DDD values are
given by the 1and1 mssql admin tool

The last thing I tried was "enable frontpage extensions" then publish using VWD, directly to <root>\main and now it acts different than it did, but still doesnt seem to work when I go to
www.cushingshops.com

Thanks for any help. All my code would be available to anyone, if we get this working. Email me for further info, or keys to access my stuff.

Re: I need Help Getting publishing my website.

It is true that 1and1 will not allow remote access to MSSQL which is a pain but it easy to work around just make a SQL Create script and run it from the mylittleadmin tool - tools - Query Analyser in the 1and1 admin section. Use aspnet_regsql to make the
script to run Query Analyser.
*****************************************************
I will try this. My question as I begin is:

<div>I need to run aspnet_regsql, and do I run it from my local machine, or do I run it from the server? I am guessing that I can run it, dos-mode, from my machine, specifying server, login-id, password, and the -sqlexportonly <filename> to generate a script.</div>
<div> </div> <div>Do I use the switch to turn all application services as I generate the original script? Do I care about SQL CACHE DEPENDENCY OPTIONS?</div> <div> </div> <div>I then move the script to my 1and1 site, <root>\main (where my website apps are),
and use the 1and1 mylittleadmin tool - tools - Query Analyser to run this script.</div> <div> </div> <div>Is this on the right track?</div> <div>Btw - my redirector script has worked fine, over the last month. I use the same script as Jeremy pointed out:</div>
<div> </div> <div>http://faq.oneandone.co.uk/script_cookbook__databases/asp_net/asp_net_2_0/1.html</div> <div> </div> <div>-Tom
</div>

Re: I need Help Getting publishing my website.

Thanks all, and especially to jeremyh who worked on this over 3 weeks, to get me up and going. As I was putting up the classified-ads starter kit, I will go back to their forum and try to leave a detailed explanation of what it took to get 1and1 to work.

Looking back, the biggest problem was probably the web.config connection string, which ended up being: