So occasionally after a run to the database I am getting the following error;
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)
It always happens after this query is executed during a page Load:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
myconnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True")
myda = New SqlDataAdapter("Select * from diaryDates", myconnection)
What does the error mean and how can I resolve it ?
View Complete Post