B
Ben
Hi
I am updating a project from Access to run on our SQL Server DB. Currently
I am struggling to connect to the database. I have this code which is
throwing this error: SQL Server does not exist or access denied.
Dim mydataadapter As New SqlDataAdapter
mydataadapter.SelectCommand = New SqlCommand(strSQL)
mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=servername\databasename;User ID=domain\username")
mydataadapter.Fill(myDataSet, "tblClient.Client_ID")
myDataGrid.DataSource = myDataSet.Table("tblClient.Client_ID")
myDataGrid.DataBind()
Any ideas
Thanks B
I am updating a project from Access to run on our SQL Server DB. Currently
I am struggling to connect to the database. I have this code which is
throwing this error: SQL Server does not exist or access denied.
Dim mydataadapter As New SqlDataAdapter
mydataadapter.SelectCommand = New SqlCommand(strSQL)
mydataadapter.SelectCommand.Connection = New SqlConnection("Data
Source=servername\databasename;User ID=domain\username")
mydataadapter.Fill(myDataSet, "tblClient.Client_ID")
myDataGrid.DataSource = myDataSet.Table("tblClient.Client_ID")
myDataGrid.DataBind()
Any ideas
Thanks B