scripter73
Programmer
Hi,
I'm setting up my IIS (version 5.0) to run ASP scripts. My web server is serving ASP pages correctly because I did a test page, but when I run my main code, I keep getting the error "0x800401F9" - Error in the DLL. I'm just trying to read an Access database from an ODBC. Does anyone know what could be wrong? My code is below. It worked on my machine at work but at home, no go. I'm runnig Win 2K Server/Access 2K database.
Any help is appreciated.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Read Agent Records</title>
<style>
BR.page { page-break-after: always}
</style>
</head>
<body><font face="Verdana, Arial, Sans-Serif" color="black" size="2">
<%
set conn = server.createobject("ADODB.Connection"
conn.open "c:\inetpub\
Set RS = server.createobject("ADODB.Recordset"
conn.execute("SELECT * From Agents"
response.write "<br>"
rs.movefirst
do
response.write FormatDateTime(Date,1) & "<br><br><br><br>"
'response.write rs("agencynum" & "<br>"
response.write rs("agencyname" & "<br>"
response.write rs("agencyaddr" & "<br>"
'response.write rs("acity" & "¸" & " " & response.write rs("astate" & " " & response.write rs("azip" & "<br>"
response.write rs("acity"
response.write ", "
response.write rs("astate"
response.write " "
response.write rs("azip" & "<br><br>"
'response.write rs("aphone" & "<br>"
'response.write rs("altphone" & "<br>"
'response.write rs("aemail" & "<br>"
'response.write "<br>"
response.write "Dear contact person, <br><br> Please read this information and let me know what you think."
response.write "<br class=page>"
rs.movenext
loop until rs.eof
rs.close
conn.close
%>
</font>
</body>
</html>
I'm setting up my IIS (version 5.0) to run ASP scripts. My web server is serving ASP pages correctly because I did a test page, but when I run my main code, I keep getting the error "0x800401F9" - Error in the DLL. I'm just trying to read an Access database from an ODBC. Does anyone know what could be wrong? My code is below. It worked on my machine at work but at home, no go. I'm runnig Win 2K Server/Access 2K database.
Any help is appreciated.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Read Agent Records</title>
<style>
BR.page { page-break-after: always}
</style>
</head>
<body><font face="Verdana, Arial, Sans-Serif" color="black" size="2">
<%
set conn = server.createobject("ADODB.Connection"
conn.open "c:\inetpub\
Set RS = server.createobject("ADODB.Recordset"
conn.execute("SELECT * From Agents"
response.write "<br>"
rs.movefirst
do
response.write FormatDateTime(Date,1) & "<br><br><br><br>"
'response.write rs("agencynum"
& "<br>"response.write rs("agencyname"
& "<br>"response.write rs("agencyaddr"
& "<br>"'response.write rs("acity"
& "¸" & " " & response.write rs("astate" & " " & response.write rs("azip" & "<br>"response.write rs("acity"
response.write ", "
response.write rs("astate"
response.write " "
response.write rs("azip"
& "<br><br>"'response.write rs("aphone"
& "<br>"'response.write rs("altphone"
& "<br>"'response.write rs("aemail"
& "<br>"'response.write "<br>"
response.write "Dear contact person, <br><br> Please read this information and let me know what you think."
response.write "<br class=page>"
rs.movenext
loop until rs.eof
rs.close
conn.close
%>
</font>
</body>
</html>
