LINQ ISSUE

Question

0.00/5 (No votes)

See more:

I used LINQ to insert,update data to database(Sql server),
it is working fien with our local server,but as i deployed it to client server....it stopd working.....
it give me an error
'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)'
as soon as i change to our traditional add/edit(sqlcommand)...it works fine....but i could not find what`s the problem???

plz reply,if anyone have any idea about it....bcoz i used it almost everywhere to add/edit data to database

Thanks in advance,
Sunita

Posted 19-Aug-10 3:00am

JMAboliEnrich

Add a Solution

4 solutions

Solution 2

i checked SQL configuration.......its the same n my issue is why it is giving error now.........erlier it was working fine..why??????

Posted 19-Aug-10 23:15pm

JMAboliEnrich

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nyarost · Accepted Answer · 2010-08-19T03:33:00

Solution 1

Ok, I am not C# guru. :D depending on error I can say that you should check SQL server configuration.

Posted 19-Aug-10 3:33am

Nyarost

souidi abderrahman · Accepted Answer · 2010-08-27T02:12:00

Solution 3

try to verify if you sql server accept remote machine or tcpip connection (from sql mconfiguration manager)? :)

Posted 27-Aug-10 2:12am

souidi abderrahman

#realJSOP · Accepted Answer · 2010-08-27T02:22:00

Solution 4

Did you verify that the connection string is correct? It sounds like the connection string may not be appropriate for their server, or their server is configured incorrectly.

Posted 27-Aug-10 2:22am

#realJSOP

Updated 27-Aug-10 2:25am

v3