Connection String Problem

Question

Pls Help Me i deployed my mvc project using entity framework on somee.com but i got connection string runtime error

Answer 1

Your question does not have full details.

 

what error are you getting?

Answer 2

Your connection string does not seem to be in correct format.

 

can you post your connection string?

Answer 3

There might be a typo in your connection string. Please verify it. 

Answer 4

please Show us your error.

Answer 5

put breakpoints and debug

Answer 6

<connectionStrings>  

        <add name="connectionname" connectionString="Data Source=Desktop123;Initial Catalog=mydb;Persist Security Info=True;User ID=sa;Password=123"

 providerName="System.Data.SqlClient" />
    </connectionStrings>

Answer 7

Check your connection string. If you need help with it check Connection Strings, which has a list of commonly used ones.

Commonly used Connection Strings:

SQL Server 2012

Standard Security

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Trusted Connection

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Connection to a SQL Server instance

The server/instance name syntax used in the server option is the same for all SQL Server connection strings.

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername; Password=myPassword;

SQL Server 2005

Standard Security

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Trusted Connection

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Connection to a SQL Server instance

The server/instance name syntax used in the server option is the same for all SQL Server connection strings.

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

MySQL

Standard

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Specifying TCP port

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Oracle

Using TNS

Data Source=TORCL;User Id=myUsername;Password=myPassword;

Using integrated security

Data Source=TORCL;Integrated Security=SSPI;

Using ODP.NET without tnsnames.ora

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;

Answer 8

error

 

Answer 9

Try this. hope this will help 

 

https://stackoverflow.com/questions/26256988/determine-correct-connectionstring-for-web-publishing-for-asp-net-mvc-applicatio