My webproject successfully run on local server ,but when i run it online it cannot run properly. Without database web page run properly but with SQL Server Databese it cannot run. How I can run my project online?

 subhamajumdar,

Are you using an MDF file in the APP_Data Folder or are you connecting to an SQL Database Server?

I am developing my web project in two way ,that is-

1. Using Access Databse:- Here I am using DSN with MS Access Database.

My web Config File's Connection String like as-

<connectionStrings>
        <add name="Hello_World.My.MySettings.HelloWorldConnectionString"
            connectionString="Dsn=TestDB1;uid=admin;PWD=abc2006" providerName="System.Data.Odbc" />
    </connectionStrings>

2.Using SQL Server Databas:-Here I am Using Connection String.

My web Config File's Connection String like as-

<connectionStrings>
<add name="Hello_World.My.MySettings.HelloWorldConnectionString"
connectionString="Data Source=ICIAT3;Initial Catalog=TestDB;User ID=sa;pwd=master"
providerName="System.Data.SqlClient" />
</connectionStrings>

But in both cases I am unable to show my web project online.
When I am upload my project with database,it run successfully but using database(MS Access or SQL Server) it shows error message.

Please give me a solution.