Help Finding a Web Hosting Service (UK)

[Jeff]

Hello

I'm teaching myself web programming in ASP.NET using freely available online
resource and videos. It's going really well and I've built myself some
personal web pages based on the Visual Studio 2005 personal website starter
kit. I now want to take the next step and put these up on a public server
but I'm getting confused by what services I need - in particular whether I
need SQL services.

I've developped in ASP.NET 2.0 and I'm using the standard PhotoManager
pbject which links in to a SQL database so I'm assuming that means I need to
have SQL 2005 available. It seems though that many of the personal web
hosting services that offer ASP 2.0 and above don't offer SQL 2005 in their
budghet packages - it tends to come in at the business level. The price
difference is significant so I don't want to get this wrong. I know that
Visual Studio 2005 comes with a version of SQL 2005 - and I assume I'll need
this available on my Web Hosting Service if I'm using the Photomanager and
other data based controls?

So, can anyone recommend a company that can provide web hosting services
that will support a site built from the Visual Studio 2005 personal website
starter kit - I need about 500MB of space and I'm UK based btw.

Thanks for any help
Jeff

 

[Jeff]

http://www.hostinguk.net/services/CompareSharedWindows08.asp

I'd go for the Pro version at £7.95 a month rather than the Starter
version, which is aimed at an absolute entry-level. I appreciate that you
describe yourself as a beginner, but good beginners tend to make fairly
rapid progress and I'm sure that if you go for the Starter version now
just to save yourself three quid a month, you'll very soon need one or
more of the features available only in the Pro version and above.

Technical support is available 24 hours a day.

ASP.NET 3.5 is fully supported.

SQL Server 2005 is fully supported (2008 is on its way).

And the fully web-based Plesk administration system is little short of
astounding.

I've been with them for over 5 years now and use them for all of my own
sites and all of my clients' sites.

Thanks

I already tried a company offering shared web servers but it turned out that
their SQL servers ran on a different machine from their web servers and
apparently this causes some problems - in a nutshell a website derived from
the personal web starter kit won't work on this configuration due to the
need for a local sql server. I think I have that right??

I spoke to the sales guys at hostinguk and they say their configuration will
be fine for my application - I will need the Pro version though as you say.

Can you (or anyone else) confirm that HostingUK's Pro service will indeed be
suitable for a site derived from the Microsoft personal web starter site?

Thanks again
Jeff

 

[Jeff]

A quick update on this.....

I signed up with HostingUk and after a few false starts pushed my site
across.

There is indeed an issue with the sql databases. The Visual Studio personal
website starter kit uses two local sql express databases - ASPNETDB.mdf to
store users and roles and Personal.mdf to store your photo album. Simply
pushing these across as is will not work on most commercial asp sites since
they run full sql servers on separate machines from the webserver. This
means that you need to trranslate the two databases from express to full sql
databases and then change the connection string in the application
accordingly. I guess this makes it a pain to maintain a local and a remote
copy of the website.

The support guy at HostingUK is promising to help me through this exercise
once a few other issues have been sorted out. I'll keep you posted about the
outcome.

Another important issue is that sql database storage costs are many times
more expensive than regular website storage costs so the idea of storing
your piccies in a sql database is not really a good idea. I have to say
though that what promised to be a very simple exercise is proving to be
anything but. I mean why are MS providing a personal web starter kit that
will only operate on your local machine - that's not really a web site is
it?

Thanks
jeff

 

[Jeff]

Not a good idea anyway, IMO... Why would you want to store pictures in a
SQL Server database, especially in a web environment?


As I understand it, the personal web starter kit is designed as an
introduction to web development - nothing more...

Thanks.

Yes, it would seem like storing photos in a sql database might not be a good
idea from a commercial point of view. Presumably the reason that a byte
costs more on a sql server than on a web server is because that byte might
involve significantly more processing that a simple http transfer and also
because it will need to be kept more securely? Any other reason?

Anyway, this is a learning exercise so I'm not too bothered about
practicality. The problems with migrating to a commercial server have
higlighted gaps in my understanding so if I manage to overcome these
problems it will have been a valuable exercise.

Thanks again
Jeff

 

[Jeff]

Thanks Mark

Do you use Visual Studio to develop your ASP.Net website?
If so, could I just check with you how you upload your website to Hosting
UK?

In particular do you use the Publish Website option under Build and enter
the ftp location of your httpdocs folder?
Or do you do a copy website?

If I understand correctly you need to publish in order to push the compiled
dll's across to the site otherwise they'll need to be built on the local
machine? But I could well be wrong, I very new to this stuff!

Thanks for any advice

Jeff

 

[Jeff]

No way! I use the Web Deployment Project add-in:
http://www.google.co.uk/search?sour...GB252GB252&q="Web+Deployment+Projects"+2008+"

Thanks for that - I assume there is something similar for 2005?
Can I ask why you don't like the publish option?




Could I just ask one other question regarding databases?
Apparently I can't just copy my SqlEpress databases across to HostingUK's
sql server. I needed to create new databases and then use a script to
transfer the data across. This was a bit tricky but worked eventually and
was a useful learning exercise.

The next issue though is to set theconnection strings in my web.config to
use the new databases rather than a local SqlExpress Database.
HostingUK advised me that I should have something like this :-

Driver={SQL Native
Client};Server=sql6.myhostcp.com;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

But if I try replacing the strings on my local machine with this type of
string then I get a complaint that the keyword "Driver" is not supported. I
haven't yet got to a position where I'm able to try this on the HostingUK
webserver so I can;t say if it works there or not.

But, if I try to configure a new sql database within Visual Studio using the
location, name and password for my database it produces a string of the
form:-
Data Source=sql6.myhostcp.com;Initial Catalog=myDataBase;Persist Security
Info=True;User ID=myUsernamePassword=myPassword"

And what's more when I use the test connection option in Visual Studio with
this string I am able to retrieve all my data in tabular form.

Would you or anyone else reading this happen to know what's going on here?

Thanks again

Jeff

 

[Jeff]

Thanks a million Mark - seems to be going great now.

Everything is working on the HostingUK site except for my Microsoft
Silverlight DeepZoom control which works fine on my local machine.

Can you or anyone else see anything obviousy wrong with the following :-

<object data="data:application/x-silverlight,"
type="application/x-silverlight-2-b2" style="z-index: 100; width: 206px;
height: 245px;" >

<param name="source" value="DZ/TestProject/DeepZoomProject.xap"/>

<param name="onerror" value="onSilverlightError" />

<param name="background" value="white" />

<param name="initParams" value="InitViewportOriginX=1,InitViewportOriginY=1"
/>

<a href="http://go.microsoft.com/fwlink/?LinkID=115261"
style="text-decoration: none;">

<img src="http://go.microsoft.com/fwlink/?LinkId=108181" alt="Get Microsoft
Silverlight" style="border-style: none"/>

</a>

</object>


The Directory DZ/TestProject/... is located in httphosts as is the aspx page
containing the above.

I'm thinking that I may need to set an absolute or relative path somewhere?

Thanks again
Jeff

 

[Jeff]

Sorry to reply to my own posting.....

The problem with the silverlight control was caused by the Web Server not
being configured to recognize Silverlight MIME types.
It's now sorted.

Jeff