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

I previously wrote article SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported where I discussed how downloading Visual Studio SP1 will fix the error of Visual Studio 2008 connecting to SQL Server 2008. I have provided link to SP1 which was downloading only installer and after that it downloads SP1 component from internet.

.NET Expert Vidya Vrat Agarwal has pointed out that Visual Studio SP1 can be downloaded as ISO. It is really good that now after downloading only one it can be used again to installed SP1 on multiple computers.

Download Microsoft Visual Studio 2008 Service Pack 1 (iso)

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

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

  1. Pingback: SQL SERVER 2008 - Connect Visual Studio 2005 Patch Download Journey to SQL Authority with Pinal Dave

  2. 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s