Hello Everyone,
Before I mention details,I would liek to say that I am new to LINQ.For now I am using only one table and I am trying to insert a record into this particular table.
Here is the code:
e_CropDataContext db = new e_CropDataContext("C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\e-Crop.mdf");
protected void Buttonaccept_OnClick(object sender, EventArgs e)
{
ferti_odigy fer_odig = new ferti_odigy
{
KalliergitikoStadio=txtagrilevel.Text
};
db.ferti_odigies.InsertOnSubmit(fer_odig);
try
{
db.SubmitChanges();
}
catch (Exception mes)
{
Console.WriteLine(mes);
db.SubmitChanges();
}
}
my problem lays on the following message:
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I have checked the disabled firewall,Remote connections(using Both TCP/IP and named pipes and the SQL Server Browser(startup type-Automatic)
I would really appreciare your "lights" on this issue.
Thank you in advance
View Complete Post