Hi, i have SQL Server 200 desktop engine installed on my machine. and i tried to connect to the Northwind database that comes with sql server 2000 using VB.Net. I am getting following error.
c:\inetpub\wwwroot\SQLserver_conn\WebForm1.aspx.vb (26):
Declaration expected.
Declaration expected
Type 'SqlConnection' is not defined.
Type 'SqlCommand' is not defined.

so i think i am having problem with Import System.Data and Import System.Data.SqlClient

My code is as follow:
Import System.Data
Import System.Data.SqlClient

Public Class WebForm1
    Inherits System.Web.UI.Page
    Protected WithEvents dgNameList As System.Web.UI.WebControls.DataGrid

#Region " Web Form Designer Generated Code "

    'This call is required by the Web Form Designer.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        Dim strConnection As String = "server=(local)\NARESH-SIR; database=Northwind; integrated security = true;"
        Dim objConnection As New SqlConnection(strConnection)
        Dim strSQL As String = "Select FirstName, LastName, Country from Employees"
        Dim objCommand As New SqlCommand(strSQL, objConnection)
        objConnection.open()
        dgNameList.DataSource = objCommand.ExecuteReader()
        dgNameList.DataBind()
        objConnection.close()

    End Sub

Can anyone help me please.

I am sory, i am having problem with the connection string. connection string doesn't seem to work

Your imports statements don't look right. They should be like this:

Imports System.Data
Imports System.Data.SqlClient

Check out http://www.connectionstrings.com for connection string options.

hi i used this connection string:
Dim strConnection As String = "Server=NARESH-SIR\Naresh;Database=Northwind;Trusted_Connection=T rue;".
I get the following error
 System.Data.SqlClient.SqlException: SQL Server does not exist or access denied
what i have is i have installed XP on my machine. and when i installed SQL server 2000, i just didn't put password because i used the windows authentication. so when i log into sql server 2000, i don't have to put any user name and password. i can just work on database. so i got cunfused should i use trusted_connection or standard security. i tried both but didn't seem to work

thanks for help

You have installed SQL Server as a named instance on your box? If not- the server name should just be the name of the machine. I don't understand why your using NARESH-SIR\Naresh

Set Trusted Connection to TRUE and then you need to give rights to the user accessing the database- which isn't you. It's the proccess .NET runs under.. which I think is ASPNET .. but you should check your machine to be sure.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee