Hi im trying to connect an asp page to SQL Server(localhost), but i keep getting errors, and im a little bit stuck where to go from here. Not sure what details help decie whats wrong so i've pasted the code and error below. I can tell you that i can connect ok with a .Net application using the same connection string/username. there is no password. SQLServer Authentication is set to "SQL Server and Windows" and the username is in the Users list on the DB.
Code:
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Q2A;User Id=Matt Inckle;Password=;"
%>
Error:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'Matt Inckle'.
/what1/test.asp, line 4
Thanks for your time !!!
Code:
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Q2A;User Id=Matt Inckle;Password=;"
%>
Error:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'Matt Inckle'.
/what1/test.asp, line 4
Thanks for your time !!!