Configuring Connection string in Shared ASP.Net Hosting

spp020
 
on Mar 24, 2013 05:15 AM
4199 Views

I have developed an e-comm web site in asp.net with sql server as a database. Now I want to upload that web site with DB to hosting server.

This is my first web hosting and I don't know how to do it.

I've created the DB script to recreate the DB at the hosting server, but I don't know how to run it on server. Please tell me how to do this.

Please tell me what changes need to be done in my connection string in web.config file for connecting the DB which will be on hosting server.

 

I also have ftp client "Filezilla" which i am able to use for uploading static html pages on server.

Also tell me, are there any kind of free hosting services available for testing my E-comm web site online?

 

My connection string is:

<add name="DBCS" connectionString="data source=(local)\SQLEXPRESS;database=LAAFOOD;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>

Thanx in advance.

 

Download FREE API for Word, Excel and PDF in ASP.Net: Download
arjunsingh
 
on Mar 24, 2013 06:24 AM

Your Connection string is wrong .Please use the connection string provided by the database company.It will have your username and pass.

example

<add name="ConnectionString" connectionString="Server=(name of the server you purchased for hosting);Database=yourdatabasename;UID=(Idprovidedto you);Pwd=(Yourdatabasepassword);" providerName="System.Data.SqlClient"/>
</connectionStrings>

 

For scripts to add :-

go into your database table below is Add scripts option ...And add your script there..But it only work when your connection string is in well format