Hi all!
I'm having a problem connecting to SQL Express with VB 2005 Express.
The Calendar.mdf file is in the same folder as the forms for the project.
That is, the folder VB express puts them in. When I try the following code
I get this:
Cannot open database "Calendar.mdf" requested by the login. The login failed.
Login failed for user 'HomePC\John'

Dim conn As SqlClient.SqlConnection
conn = New SqlClient.SqlConnection
conn.ConnectionString = "Data Source=.\SQLExpress;Initial Catalog=Calendar.mdf;Integrated Security=True"

Dim cmd As Data.SqlClient.SqlCommand
cmd = New Data.SqlClient.SqlCommand
cmd.CommandType = CommandType.Text
cmd.CommandText = "Select ItemDate from Items"
cmd.Connection = conn

Dim ds As New Data.DataSet("Items")
Dim da As New Data.SqlClient.SqlDataAdapter(cmd)
da.Fill(ds)

Thanks in advance for any help you can give me