Member Avatar for rakibuddin ali

Sir, i hv a problem with database? in my PC i have sql server (develop) edition 2000 and MS-SQL server 2005 (sql server management studio express CTP) . In my web page asp.net (vb.net) data connection is succedded. But when i run the web page and fill up the text boxes and click on the save button an error message will display like (A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
My code is

Imports System.Data.SqlClient
Partial Class _Default
    Inherits System.Web.UI.Page
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim con As New SqlConnection("server= LAB3; database= third")
        Dim cmd As New SqlCommand
        cmd = New SqlCommand("insert into eye values (' " & TextBox1.Text & " ',' " & TextBox2.Text & " ',' " & TextBox3.Text & " ',' " & TextBox4.Text & " ')", con)
        con.Open()
        cmd.ExecuteNonQuery()
        con.Close()
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim con As New SqlConnection("server= LAB3; database= third")
        Dim cmd As New SqlCommand
    End Sub
End Class
Edited by Dani because: Added code tags
  • 2 Contributors
  • 1 Reply
  • 94 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

Change the connection string. Use Server Explorer menu item to get correct connection string.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.