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

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)

GET /BegASPFiles/Connect.asp

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

More information:
Microsoft Support

Here is code:
  Option Explicit
  Dim strConnect

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

  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>"

  Set objRS = Nothing
  Set objConn = Nothing


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