Hello,

I have found a nice solution to upload my file to a live server offering sqlexpress support, just free.

I have tried several times to attach, but it fails and throws an error. I need to upload my full beer house site immediately.

Can anyone come forward providing me the exact web configuration connecting string as well any other details required for remote hosting. I have not seen any discussion regarding remote hosting with sqlExpress in thsi forum so far.

I have already uploaded the full site and this is the only thing left.

Thanks

SoftMind.

that happens couse a wrong connection string.
What kind of server is it.. sql express or sql server 2005

A remote Sql Express is basically the same as a remote full Sql Server from a deployment point of view. You have to deploy the same way you would for a remote full Sql Server. The deployment chapter covers this in detail.

By the way, I'm surprised that a commercial hosting company is using the Express version, since the full version is quite affordable if you have a lot of users to spread that cost out, and the full version is faster if the server has a lot of memory. But the Express version will work fine as long as your DB stays under it's size limit.

Eric

Hello,

www.freewebdot.com

This is the link. This is a site that is offering everything free in hosting. They are also offering sql2000 and SqlExpress just free with a huge database and space support.

i have already uploaded all the codes and waiting for the connection string to work.

I understand that BeerHouse works perfectly with sqlexpress, hence i need a connection string which can work with the hosting coompany.

They have mentioned on the site that you just need to upload the code with data and use connection string to fetch that data.

I have tried connection strings in many ways, but it fails. Pl. come ahead and help me. This topic will be very useful for all programmers, who needs to work online with beerhouse with sqlexpress

Hello,
This is the solution as provided by the hosting company for sqlexpress connection string.
-----------------INSTRUCTION ONE----------------------------------
To upload MSSQL 2005 Express or MS Access database (*.mdf or *.mdb) file you need to upload it using your favorite FTP client. Then you can connect it from your scripts.
------------------INSTRUCTION TWO----------------------------------
You must add to your connection string following unique value:

Code:

Database=UniqueRandomHashOrDBName

For Example:
Database=MyDatabaseJZb65bjk


Whole connection string:

Code:
Database=UNIQUEHASHVALUE;Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|dbna me.mdf


For more informations about ASP.NET visit main website http://www.asp.net.

This topic is discussed here.
http://faq.freewebdot.com/index.php?...=35&artlang=en

Pl. provide us a webconfig file connection string for BeerHouse, based on this guidelines.

Thanks

SoftMind.