Base provider could not open

Question

Hi

I am using VS2010 and working with Microsoft Entity Framework 4.0

I am working on a windows application. I have linked several combos in my application; It works fine.

void BindNatureOfIndustryCombo()
{
    using (var obj = new EASDBEntitiesCon())
    {
        var natureOfIndustryColl = from c in obj.IndustryTypes select c;
        var natureOfIndustryList = natureOfIndustryColl.ToList();

        cmbNatureOfIndustry.DataSource = natureOfIndustryList;
        cmbNatureOfIndustry.DisplayMember = "IndustryType";
        cmbNatureOfIndustry.ValueMember = "IndustryTypeID";

    }
}

ConnectionString

<add name="EntrpriseApplicationSuit.Properties.Settings.EASDBConnectionString" connectionString="Data Source=192.168.0.150\GSERVER;Initial Catalog=EASDB;Persist Security Info=True;User ID=sa;Password=$1234;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

But when I run my application on another system, it gives an error:

Base provider could not open

Why does this error occur and what is the solution?

Answer 1

This indicates that the connection string is incorrect from another computer. Perhaps he is using Windows authentication, and another user or computer does not have access to it - or perhaps he is on a different network and cannot communicate with the server? We cannot really diagnose this without knowing a little about what he is trying to connect to.

, , , - , , , .

Answer 2

!

, / , , () .

Answer 3

(DTC) . DTC MSDTC .

Open DTC by going to "Component Services / Computers / My Computer" / "Distributed Transaction Coordinator" / right-click "Local DTC / Properties / Security tab / Verification. Enable network access to DTC and allow remote to customers.