I am trying to test my connection to a SQL datbase and I am receiving the
following error(line 13 in oConn.Open line):
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.
/afniwanTest.asp, line 13
Please look over my code and tell me what I am missing!
<htmL>
<head><title>AFNIWAN TEST PAGE</title>
</head>
<body>
<h2>This page will test the connection to the AfniWAN database.</h2>
<%
SET oConn = Server.CreateObject("ADODB.connection")
SET oRS = Server.CreateObject("ADODB.recordset")
Response.Write "I am Chris McBride"
Response.Flush
oConn.Open "DSN=prog02afniwan"
oRS.Open "BackupLog", oConn
Response.Write "<BR>I am Chris McBride in line 17"
oRS.close
SET oRS = nothing
oConn.close
SET oConn = nothing
%>
</body>
<htmL>
View Cart
