My database (ms access) is in ftp;
i want to transfer the one particular table content to local db which is in my system...
the coding i written was
' for local database connection
<%
strconnect="Pro vider=Microsoft .Jet.OLEDB.4.0; Data Source=" & strpath & " ; Persist Security Info=False"
set Conloc = Server.CreateOb ject("ADODB.Con nection")
Conloc.Provider ="Microsoft.Jet .OLEDB.4.0"
Conloc.Open strconnect
strdelete="Dele te * from tablename"
Conloc.execute( strdelete)
' Ftp database connection
call opendatabase()
Set rsftp= con.Execute("se lect * from tableftp")
While not rsftp.Eof
ms=rsftp.fields ("msg")
ss=rsftp.fields ("sender")
Response.Write( "Message::" & msg)
Response.Write( "Sender :: " & sender)
' str_insert="Ins ert Into tableftp(ss,ms) values( '" & ss & " ','" & ms & "')"
Conloc.Execute str_insert
rsftp.movenext
wend
call closedatabase()
End if
%>
<form name="frm1">
<center>
<label for="uploadfile "><b>File name:</b> </label>
<input type="file" name="uploadfil e" id="uploadfile" >
<br><br><br>
<button name="btnsubmit " style="backgrou nd-color:#E0DAB8" onclick="btnfil e()" value="Send"><b >Update the Database </b> </button>
<input type="hidden" name="txthid">
</center>
</form>
when i try to open i got http 505 error ..page cant be viewed,,,
please help..
i want to transfer the one particular table content to local db which is in my system...
the coding i written was
' for local database connection
<%
strconnect="Pro vider=Microsoft .Jet.OLEDB.4.0; Data Source=" & strpath & " ; Persist Security Info=False"
set Conloc = Server.CreateOb ject("ADODB.Con nection")
Conloc.Provider ="Microsoft.Jet .OLEDB.4.0"
Conloc.Open strconnect
strdelete="Dele te * from tablename"
Conloc.execute( strdelete)
' Ftp database connection
call opendatabase()
Set rsftp= con.Execute("se lect * from tableftp")
While not rsftp.Eof
ms=rsftp.fields ("msg")
ss=rsftp.fields ("sender")
Response.Write( "Message::" & msg)
Response.Write( "Sender :: " & sender)
' str_insert="Ins ert Into tableftp(ss,ms) values( '" & ss & " ','" & ms & "')"
Conloc.Execute str_insert
rsftp.movenext
wend
call closedatabase()
End if
%>
<form name="frm1">
<center>
<label for="uploadfile "><b>File name:</b> </label>
<input type="file" name="uploadfil e" id="uploadfile" >
<br><br><br>
<button name="btnsubmit " style="backgrou nd-color:#E0DAB8" onclick="btnfil e()" value="Send"><b >Update the Database </b> </button>
<input type="hidden" name="txthid">
</center>
</form>
when i try to open i got http 505 error ..page cant be viewed,,,
please help..
Comment