What is the correct connection string for SQL 2000 server in entity framework
- by M-Askman
I success to use entity framework for MySQL but reverse code can not be used with SQL Server 2000, then i guess to change connection string to connect SQL Server 2000, however, got error
<add name="BetterContext" connectionString="Data Source=server2;Initial Catalog=GoodDB;User ID=sa;Password=hello;MultipleActiveResultSets=True;"
providerName="System.Data.SqlClient" />
An error occurred while getting provider information from the database.
This can be caused by Entity Framework using an incorrect connection string.
Check the inner exceptions for details and ensure that the connection string is correct
public partial class BetterContext : DbContext
{
static BetterContext()
{
Database.SetInitializer<BetterContext>(null);
}
public livefeedContext()
: base("Name=BetterContext")
{
}
