Hello,
Using VS 2005 & SQL 2005

This is my first time in programming a PDA, i want to connect to a SQL server. both are on my computer.

The code below works fine for a windows application, but when I try and implement it on a PDA application it comes up with "SQL Server does not exist or access denied" This code does work as it has been tested in a windows form.

Is it best to connect to a XML Web Service and return the ds? So the code below will be in the web service. I am not sure about this as this my first time.

Can anyone offer any direction?

Code:
Private Sub btnIncidents_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnIncidents.Click
        Dim cmd As New SqlCommand()
        Dim cnn As New SqlConnection()
        Dim da As New SqlDataAdapter()
        Dim ds As New DataSet

        Try
            cnn.ConnectionString = "server=(local); database=serviceMaster; integrated security=true"
            'server=steve01\ssd01; database=serviceMaster; integrated security=true
            cnn.Open()

            cmd.Connection = cnn
            cmd.CommandType = CommandType.Text
            cmd.CommandText = "SELECT IncidentID, company, contact, email, subject FROM Incidents"

            da.SelectCommand = cmd
            da.Fill(ds)

            grdIncidents.DataSource = ds.Tables(0).DefaultView

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
    End Sub
Thanks in advance,

Steve