every time I try to connect to Sql server I got this error
Login failed for user music. Reason: Not associated with a trusted SQL Server connection. Invalid connection string attribute
or any user fail even "sa"
Page Code
<%@ Page LANGUAGE="VB"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDB" %>
<SCRIPT LANGUAGE="VB" RUNAT="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim oConn As OleDBConnection
Dim sConnString As String
sConnString = "Provider=SQLOLEDB;Data Source=(local);Initial Catalog=Music;UserID=music;Password=music"
oConn = New OleDBConnection(sConnString)
oConn.Open()
oConn.Close()
End Sub
</SCRIPT>
<HTML>
<BODY>
Opening a Connection!
</BODY>
</HTML>
Can any one help
Login failed for user music. Reason: Not associated with a trusted SQL Server connection. Invalid connection string attribute
or any user fail even "sa"
Page Code
<%@ Page LANGUAGE="VB"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDB" %>
<SCRIPT LANGUAGE="VB" RUNAT="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim oConn As OleDBConnection
Dim sConnString As String
sConnString = "Provider=SQLOLEDB;Data Source=(local);Initial Catalog=Music;UserID=music;Password=music"
oConn = New OleDBConnection(sConnString)
oConn.Open()
oConn.Close()
End Sub
</SCRIPT>
<HTML>
<BODY>
Opening a Connection!
</BODY>
</HTML>
Can any one help