scripter73
Programmer
Hi,
I'm having trouble displaying the contents of my recordset. My ASP script connects to my DSN called 'webreport'. This file is on a server drive D:\. D:\ is the physical drive on the server. My client machine has full privileges to it.
It seems I'm able to open my connection alright, but when I attempt to execute my SQL query, I get the error '80004005 - Unspecified error' on my set rs = myconn.execute(sqltext). I know this error can mean several different things, from permissions to illegal usage of objects, but I'm sort of new to ASP and I'm not an NT Admin.
I've done quite a bit of research, and I've given my ISUR_<machinename> full access to both the database I'm connecting to, and the directory where both the database and my ASP script reside. I just can't seem to make this out.
Following is my code:
<html><head><title>Reading Contents of Database</title></head>
<body>
<%
'**************************
'OPEN DATABASE CONNECTION
'**************************
'create connection to database using dsn
set myconn = Server.CreateObject("ADODB.Connection"
myconn.open "FILEDSN=d:\inetpub\
'search database with query
sqltext = "SELECT * FROM Access-log"
set rs = myconn.execute(sqltext)
While Not rs.eof
response.write "<br>" & rs("IP_Address" & rs("User_ID" & "<br>"
rs.movenext
WEnd
rs.close
myconn.close
%>
</body>
</html>
Thanks in advance for your help. I really appreciate it.
scripter73
I'm having trouble displaying the contents of my recordset. My ASP script connects to my DSN called 'webreport'. This file is on a server drive D:\. D:\ is the physical drive on the server. My client machine has full privileges to it.
It seems I'm able to open my connection alright, but when I attempt to execute my SQL query, I get the error '80004005 - Unspecified error' on my set rs = myconn.execute(sqltext). I know this error can mean several different things, from permissions to illegal usage of objects, but I'm sort of new to ASP and I'm not an NT Admin.
I've done quite a bit of research, and I've given my ISUR_<machinename> full access to both the database I'm connecting to, and the directory where both the database and my ASP script reside. I just can't seem to make this out.
Following is my code:
<html><head><title>Reading Contents of Database</title></head>
<body>
<%
'**************************
'OPEN DATABASE CONNECTION
'**************************
'create connection to database using dsn
set myconn = Server.CreateObject("ADODB.Connection"
myconn.open "FILEDSN=d:\inetpub\
'search database with query
sqltext = "SELECT * FROM Access-log"
set rs = myconn.execute(sqltext)
While Not rs.eof
response.write "<br>" & rs("IP_Address"
& rs("User_ID" & "<br>"rs.movenext
WEnd
rs.close
myconn.close
%>
</body>
</html>
Thanks in advance for your help. I really appreciate it.
scripter73