Mono's SqlClient supports Integrated Security (NTLM), but you must be on a true
windows domain. A workgroup does not count. You also have to give your windows
domain user id and password. On Mono's SqlClient, you have to give your
windows domain credentials because Mono is not integrated with your Windows
workstation, nor SQL Server, nor the Windows server where the SQL Server
instance is running.
--- On Sun, 10/31/10, Paul F. Johnson <p...@all-the-johnsons.co.uk> wrote:
> From: Paul F. Johnson <p...@all-the-johnsons.co.uk>
> Subject: [Mono-list] Connecting to a database (VB)
> To: "mono-list" <mono-list@lists.ximian.com>
> Date: Sunday, October 31, 2010, 11:16 AM
> 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...
>
> _______________________________________________
> Mono-list maillist - Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
_______________________________________________
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list
