Agyekum Essien

Agyekum Essien

  • 1.4k
  • 260
  • 1.6k

DataTable works fine on Local but Not Server

Oct 6 2018 12:17 PM
It gets data populated fine  in the dataTable on local database with default Local connectionString but when I change it to use server database with connectionString by the server  is the case; Check my connectionString below:
Local:
<add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;Initial Catalog=aspnet-dataTablesPlugin-20181004044155;Integrated Security=True"
providerName="System.Data.SqlClient" />
Server:
<add name="dbcs" connectionString="Data source=Plumeria.arvixe.com; initial catalog=TestDb; Persist Security=SSPI;user id=EssienUser;password=Agyekum1;App=EntityFramework" providerName="System.Data.EntityClient" />
Thanks in advance.

Answers (1)