[RESOLVED] Trying to use SQL Client to open laptop SQL from PPC

[szlamany]

Any ideas why this won't work?

        Dim LDcn As New SqlConnection
        LDcn.ConnectionString = "Data Source=fps-lap-sz; Initial Catalog=Stufiles; User Id=apcload; Password=apcload"
        Try
            LDcn.Open()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

fps-lap-sz is the name of my laptop - it's got SQL server 2000 running on it. The ex.Message shows up as a meaningless "SqlException"

StackTrace is...

?ex.StackTrace
"at System.Data.SqlClient.SqlConnection.OnError()
at System.Data.SqlClient.SqlInternalConnection.OnError()
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run()
at System.Data.SqlClient.TdsParser.Run()
at System.Data.SqlClient.SqlInternalConnection.Login()
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor()
at System.Data.SqlClient.SqlConnection.Open()
at APC.APC.LoadDatabase()
at APC.APC.Button_Click()
at System.Windows.Forms.Control.OnClick()
at System.Windows.Forms.Button.OnClick()
at System.Windows.Forms.ButtonBase.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at APC.APC.Main()
"