Home » Categories » Multiple Categories

How To Solve Problem with Connection String on EF (Entity Framework) 4 or above

This article applies to anyone who uses Entity Framework (EF) type-of-codes on our shared server environment. Please be advised that when you host your database on our server, you will have to use the connection string on your web.config. The "usual" connection string on your web.config should be something similar to the one mentioned on this article.

If you are using Entity Framework on your code, the connection string on your web.config will look something like this:

<add name="conn_string" connectionString="metadata=res://*/App_Code.myApp.csdl|res://*/App_Code.myApp.ssdl|res://*/App_Code.myApp.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=data_source;uid=my_db_username;pwd=my_db_password;AttachDbFilename=App_Data\myApp.mdf;Integrated Security=True;Connect Timeout=30;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

Please be advised that the above connection string will not work on our server. When you have restored your database on our server, you must use the connection string determined by our server.

Therefore, to rectify the issue, you must change the connection string on your web.config to something like this:

<add name="conn_string" connectionString="metadata=res://*/App_Code.myApp.csdl|res://*/App_Code.myApp.ssdl|res://*/App_Code.myApp.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=our_SQL_Server_details;uid=my_db_uzsername;pwd=my_DB_password;Initial Catalog=my_DB_name;ConnectTimeout=30;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

Please pay close attention to the details in bold

- our_SQL_Server_details refers to the SQL Server detail specified on our Control Panel. Please see this article
- my_db_username refers to the DB_username created on our Control Panel
- my_db_password refers to the DB_password created on our Control Panel
- my_db_name refers to the DB_name created on our Control Panel

Please also take note that "Integrated Security" line on your web.config should be removed.

If you still experience issues, please contact our Support Team by raising a support ticket via our Help Desk System
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Do you support SQL Reporting Service (SSRS)?
Viewed 1556 times since Tue, May 1, 2012
Can i login to my MySQL database via my own mySQL tool?
Viewed 1416 times since Mon, May 7, 2012
Do you support SQL Server Integration Service?
Viewed 1284 times since Tue, May 1, 2012
How to solve the Let’s Encrypt SSL on ASP.NET Core
Viewed 17 times since Mon, Jul 17, 2017
My website session times out earlier than expected. Why?
Viewed 2145 times since Tue, May 1, 2012
Domain Name Server (DNS) Amplification Attack
Viewed 1436 times since Wed, Oct 15, 2014
How do I redirect a subdomain to a subdirectory?
Viewed 1766 times since Tue, May 1, 2012
Do you support MS SQL WebAdmin access?
Viewed 3092 times since Tue, May 1, 2012
How do I query MySQL database in ASP.NET?
Viewed 3363 times since Tue, May 1, 2012
What is my MS SQL Connection String on my SQL Management Studio tool?
Viewed 19039 times since Tue, May 1, 2012