[Mono-list] Connecting to a database (VB)

[Paul F. Johnson]

Hi,

I have set up a really simple MS SQL database and am trying to connect
to it using VB.

Currently, my code looks like this

Dim connstr as String = "Data Source=localhost\SQLEXPRESS;"+"Initial
Catalog="Database1\Table1;"+"Integrated Security=SSPI;"
Dim sql as String = Nothing
Dim tables as New ArrayList
Dim sqldata as new DataSet
Try
Dim connect as new SqlConnection(connstr)
connect.Open()
Dim sqlcomm as new SqlCommand(sql, connect)
sqlcomm.CommandText = "Select Name where (Age > 25 and Hometown =
Liverpool);"
Dim sqlad = new SqlDataAdapter
sqlad.SelectCommand = sqlcomm
For i = 0 to 3
  sqlad.TableMappings.Add("Table", tables(i).ToString())
Next
sqlad.Fill(sqldata)
connect.Close()
Catch ex as SqlException
WriteLine("Error " + ex.Message.ToString())
End Try

Nothing amazing. The problem is the connection string - I've googled
around and nothing seems to fit. The exception thrown is that it can't
log in for user pb5\paul. If I add User Id=paul or User Id=pb5\paul, it
still won't connect.

What is wrong?

TTFN

Paul

-- 
Vertraue mir, ich weiss, was ich mache...