Quote:
quote:Originally posted by philthy
Quote:
|
quote:Originally posted by plb
|
Quote:
I use WebHost4Life. It supports .NET 2.0 and SQL Server 2005 for the same price as other solutions. I tried to get it to work with SQL Server Express but failed. Their tools for mounting a site are not very intuitive of orthogonal but do work. They do respond back to requests for help.
http://weboperahouse.com
|
Does this mean that it's not possible to xcopy the 2005 express database to the host, even though they support SQL Server 2005?
I mean, do they actually have to support the express version specifically?
|
philthy,
I use webhost4life too and have no problems with 2005 express. in fact, i just put an amended sample of the beerhouse up there today.
plb - the main issue is perhaps the fact that you need to login to your W4L account with your db login (this takes you to the c:\db\username area). this is basically your registered login name with _db at the end of it, plus your normal password. in my case, i log onto sql381.mysite4now.com. you then upload your datafile.mdf file to there and then via the control panel, go to Database Admin->MSSQL Admin. From the selections on the centre panel, select Attach New DB and follow the intructions from there. of course, you'll need to then use a connect string in your web.config a bit like the one below:
<connectionStrings>
<remove name="MyLocalSqlServer"/>
<add name="MyLocalSqlServer" connectionString="Server=sql381.mysite4now.com;
Database=mypreferredname;uid=myuid;pwd=mypass;" providerName="System.Data.SqlClient"/>
</connectionStrings>
but all those parameters map directly to the database that you are asking the control panel to attach. i previously couldn't figure it out as i was putting a relative path to the db, rather than the server name.
hope this helps
jim
[edit] very early days and this will cahnge drastically, but here's the site that i put up today. this includes the new forum listing that i modded yesterday (see
http://p2p.wrox.com/topic.asp?TOPIC_ID=57522). i plan to deviate away quite a bit from the original but HOPE to retain the core integrity as prescribed by marco. anyway, basic 1st draft here (plb, i nicked your claret buttons temporarily just to test a few things - will give them back soon) :D :
http://www.jamestollan.com/Default.aspx