asp_ado_rds thread: File already exists when objRs.Save "c:\MyData.dat",adPersistXML
I'm getting:
Error Type:
Microsoft VBScript runtime (0x800A003A)
File already exists
/vcccd/1_SampleCode/vccccd/rsOpen.asp, line 9
from this code (essentially right out of wrox ADO 2.6)
<%
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRs = Server.CreateObject("ADODB.Recordset")
objConn.Open "dsn=pubs;uid=sa;pwd=;"
strSQL = "SELECT * FROM employee"
objRs.Open strSQL,objConn,adOpenDynamic,adLockOptimistic
objRs.Save "c:\MyData3.dat",adPersistXML
objRs.Close
Set objRs.ActiveConnection=nothing
objConn.Close
'lets use this offline
objRs.Open "c:\MyData3.dat"
While Not objRs.EOF
Response.Write objRs("emp_id") & objRs("lname") & "<br>"
objRs.MoveNext
Wend
objRs.Close
%>
What would be the best method to update the local file? Updating the
server is not a factor in this case.
Thanks
Vince