Visual Studio 2010 and SQL Server

I have upgraded to a new laptop and version of Visual Studio 2010. When I open studio and create a new project and attempt to connect to a test database on my sql 2003 server I receive a message that says "This server version is not supported" You must use sql 2005 or later. I have tried to google this error but the solutions provided seem to be for VS 2008 and not 2010. Does anyone know if there is a work around for this or am I missing someting? I can connect successfully via odbc and through enterprise manager if that means anything.
tmaususerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
hi

Mainstream support for SQL Server 2000 ended on 04/08/2008. Visual Studio 2010 only supports SQL Server 2005 and SQL Server 2008/2008 R2. In order to continue working with SQL Server 2000, you may use any of the earlier releases of Visual Studio.
 
The ODBC connection is still enabled as ODBC is version independent. You will find many features disabled for ODBC connections.

bassically NO you cant but (theres always a BUT) i saw this floating around.

Use an ODBC Connection with the connection string
 
Driver ={SQL Server}; Server =myServerAddress; Database =myDataBase; Uid =myUsername; Pwd =myPassword;






0
 
tmaususerAuthor Commented:
My apologies on the type 'o'. I am running sql server 2000 sp3 (not 2003 as first indicated).
0
 
tmaususerAuthor Commented:
Ok so I am a novice at programmng at best. I have tried this code but get an error. The error I get is on this line: Dim Global_strProdCN As String = Global_settings.ConnectionString
NullReferenceExceptionHandeled. I have not idea how to correct this given my "newbie" skills. The complete code is below.

Imports System.Data.SqlClient
Imports System.Configuration
Imports System
Imports System.IO
Imports System.Net.Mime.MediaTypeNames


Public Class Form1

    Dim Global_settings As ConnectionStringSettings
    Public Global_strProdCN As String
    Public Global_sqlProdCN As New SqlConnection
    Public Global_ERPsettings As ConnectionStringSettings
    Public Global_strERPCN As String
    Public Global_sqlERPCN As New SqlConnection
    Public Global_dr As SqlDataReader
    Public Global_sqlcmd As New SqlCommand
    Public Global_strsql As String
    Public Global_strProdCN2 As String
    Public Global_sqlProdCN2 As New SqlConnection

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Global_settings = System.Configuration.ConfigurationManager.ConnectionStrings("Data Source=SERVER04N;Initial Catalog=yamahalabeldb;Integrated Security=True")
        Dim Global_strProdCN As String = Global_settings.ConnectionString
        Dim irowcnt As Integer = -1

        Global_strsql += " SELECT Part_no, Deliverylocation, po_no, supplier_id, labelcode, qty, duedate, stocklocation, sirlocation "
        Global_strsql += " FROM yam_con_label "
        Global_strsql += " Order by part_no "
        Global_sqlProdCN = New SqlConnection(Global_strProdCN)
        Global_sqlProdCN.Open()
        Global_sqlcmd = New SqlCommand(Global_strsql, Global_sqlProdCN)
        Global_dr = Global_sqlcmd.ExecuteReader()
        If Global_dr.HasRows Then
            While Global_dr.Read
                irowcnt += 1
                Dim srow() As String = {Global_dr.Item("Part_no"), Global_dr.Item("Deliverylocation"), Global_dr.Item("po_no"), _
                                        Global_dr.Item("supplier_id"), Global_dr.Item("labelcode"), Global_dr.Item("qty"), _
                                        Global_dr.Item("duedate"), Global_dr.Item("stocklocation"), Global_dr.Item("sirlocation")}
                dgYamahadata.Rows.Add(srow)
            End While
        End If

    End Sub

    Private Sub dgYamahadata_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgYamahadata.CellContentClick

    End Sub
End Class
0
 
tmaususerAuthor Commented:
I will repost my code under another zone.
0
All Courses

From novice to tech pro — start learning today.