View Single Post
  #9 (permalink)  
Old June 13th, 2003, 06:03 PM
johngilbart johngilbart is offline
Registered User
 
Join Date: Jun 2003
Location: asheville, nc, .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'HP864N\IUSR_HP864N'.
/BegASPFiles/Connect.asp, line 23


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705; MSN 8.0; MSN 8.5; MSNbBBYZ; MSNmen-us; MSNcIA)

Page:
GET /BegASPFiles/Connect.asp

Time:
Friday, June 13, 2003, 6:59:08 PM


More information:
Microsoft Support

Here is code:
<%
  Option Explicit
  Dim strConnect
%>

<HTML>
<HEAD>
<TITLE>Using an SSI to hold the Connection String</TITLE>
</HEAD>
<BODY>

<%
  Dim objConn, objRS
  Dim adOpenForwardOnly, adLockReadOnly, adCmdTable

  adOpenForwardOnly = 0
  adLockReadOnly = 1
  adCmdTable = 2

  Set objConn = Server.CreateObject("ADODB.Connection")
  Set objRS = Server.CreateObject("ADODB.Recordset")
  strConnect = "Provider=SQLOLEDB;Integrated Security=SSPI;Data Source=HP864n;Initial Catalog=BCDataSQL"
  objConn.Open strConnect

  objRS.Open "Workcentermaster", objConn, adOpenForwardOnly, adLockReadOnly, adCmdTable

  While Not objRS.EOF
    Response.Write objRS("wcwc") & "<BR>"
    objRS.MoveNext
  Wend

  objRS.Close
  objConn.Close
  Set objRS = Nothing
  Set objConn = Nothing
%>

</BODY>
</HTML>

Test Connection OK fro Access adp front end. What else?????