T
Tony M
vs 2005 - vb .net (desktop app) - XP Pro
Trying to manipulate data form a desktop app. to a remote hosted website?
Just trying to connect for now. Anyone know what I can change to make
connection?
xxxxxx, yyyyyy and DB are substituted for real values.
Below is the code:
Imports Microsoft.SqlServer
Imports System.Data.Sql
Imports System.Data.SqlClient
Dim Con
Dim Sql As String
Sql = "Server=67.19.23.66;Database=dialer;Uid=xxxxxx;Pwd=yyyyyy;"
Con = New SqlConnection(Sql)
Try
Con.Open()
Catch ex As Exception
TextBox1.Text = ex.ToString
End Try
Below is error message:
System.Data.SqlClient.SqlException: Cannot open database requested in login
'DB'. Login fails.
Login failed for user 'xxxxxx'.
at
Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method
TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
at
Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container
BaseReference, String MethodName, Object[] Arguments, String[]
ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags
InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object
Instance, Type Type, String MemberName, Object[] Arguments, String[]
ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean
IgnoreReturn)
at DialerTest.frmDialerMain.btnCreateDB_Click(Object sender, EventArgs e)
in C:\DialerTestFolder\DialerTestVB\DialerTest\Form1.vb:line 17
Thank You
Trying to manipulate data form a desktop app. to a remote hosted website?
Just trying to connect for now. Anyone know what I can change to make
connection?
xxxxxx, yyyyyy and DB are substituted for real values.
Below is the code:
Imports Microsoft.SqlServer
Imports System.Data.Sql
Imports System.Data.SqlClient
Dim Con
Dim Sql As String
Sql = "Server=67.19.23.66;Database=dialer;Uid=xxxxxx;Pwd=yyyyyy;"
Con = New SqlConnection(Sql)
Try
Con.Open()
Catch ex As Exception
TextBox1.Text = ex.ToString
End Try
Below is error message:
System.Data.SqlClient.SqlException: Cannot open database requested in login
'DB'. Login fails.
Login failed for user 'xxxxxx'.
at
Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method
TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
at
Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container
BaseReference, String MethodName, Object[] Arguments, String[]
ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags
InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object
Instance, Type Type, String MemberName, Object[] Arguments, String[]
ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean
IgnoreReturn)
at DialerTest.frmDialerMain.btnCreateDB_Click(Object sender, EventArgs e)
in C:\DialerTestFolder\DialerTestVB\DialerTest\Form1.vb:line 17
Thank You