Can you please help me with the following ASP error:
Error Type:
ADODB.Record (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/begasp/recordmove.asp, line 25
My System: Windows XP Professional SP2 and IIS 5.1
This is the full asp code:
Code:
<%option explicit %>
<!-- metadata type="typelib"
FILE="c:\program files\common files\system\ado\msado15.dll" -->
<html>
<head>
<title>Retrieving semi-structured Data</title>
</head>
<body>
<%
if request.form("task")="" then %>
<form name=movieinfo action="recordmove.asp" method="post">
what do you want to do? <br><br>
<input type="radio" name="task" value="copy" checked>
Copy Mytext.txt to a new file called mytext2.txt</input><br>
<input type="radio" name="task" value="move">
move Mytext.txt to a new file called mytext2.txt</input><br>
<input type="radio" name="task" value="delete">
delete Mytext.txt from the begasp file</input><br>
<input type=submit value="go">
</form><%
else
dim objrecord
set objrecord = server.CreateObject("adodb.record")
objrecord.Mode=adModeReadWrite
objrecord.open "mytext.txt","url=http://sony415s/begasp"
if request.form("task")= "copy" then
objrecord.copyrecord "", "http://sony415s/testfolder/mytext2.txt",,,adcopyoverwrite
response.write "mytext.txt file copied to a new file called mytext2.txt"
elseif request.form("task")= "move" then
objrecord.moverecord "", "http://sony415s/testfolder/mytext2.txt",,,adcopyoverwrite
response.write "mytext.txt file moved to a new file called mytext2.txt"
elseif request.form("task")="delete" then
objrecord.deleterecord
response.write "mytext.txt has been deleted"
end if
objrecord.close
set objrecord = nothing
end if
%>
</body>
</html>
.
The error on line number 25 contains the following code:
objrecord.open "mytext.txt","url=http://sony415s/begasp"
The syntax of the code is correct because when I add IUSR_machinename to the Administrators group the code works and runs everything with anonymous user Iusr_machinename and it copies the record from the begasp virtual directory to the testfolder virtual directory.
I have given Iusr_machinename ntfs access to both folders by setting read permission for BEGASP physical path which is c:\inetpub\wwwroot\begaspfiles and read and write permission for the TESTFOLDER physical path which is c:\inetpub\wwwroot\testfolder.
Also Iusr has read permissions to the windows,system,system32, inetsrv,ado,msado15.dll directories and file. I have checked local security policy to make sure iusr_machinename can log on locally.
I think the asp code does not work because the Iusr_machinename is missing a permission somewhere to access the
http://sony415s/begasp local server.
Can someone please help me solve this.