SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download

3 Comments. Leave new

• 

  Manish Soni

  April 19, 2012 11:37 pm

  i want to add data in sql server 2008 using vb 2010 .
  progarm executing without any error but no record update in sql server database
  please help……………..

  Imports System.Data.SqlClient

  Public Class Form1
  Dim CONN As New SqlClient.SqlConnection
  Dim CMD As New SqlCommand
  Dim AD As New SqlDataAdapter
  Dim DS As New DataSet

  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  CONN.ConnectionString = (“DATA SOURCE=.\SQLEXPRESS; ATTACHDBFILENAME=|DATADIRECTORY|\DATABASE1.MDF;INTEGRATED SECURITY = TRUE; USER INSTANCE=TRUE”)
  CMD.Connection = CONN
  CMD.CommandText = ” INSERT INTO DETAIL (NAME,LASTNAME,AGE) VALUES(‘” & TextBox1.Text & “‘,'” & TextBox2.Text & “‘,'” & TextBox3.Text & “‘)”
  CONN.Open()
  CMD.ExecuteNonQuery()
  CONN.Close()

  End Sub

  End Class

  Reply
  • 

    Amit Kumar Sharma

    February 10, 2015 12:00 pm

    Dear Sir,

    I have installed MS Visual Studio 2008 service pack 1 but still same problem persist

    Please advise

    Thanks

    Reply
    • 

      Mike

      May 25, 2016 2:06 am

      did you ever get a fix for this, I am having same problem