I plan to creat Remote Recordset from Msaccess, but the following code not work, I think it must be some errors in
<PARAM NAME="CONNECT" VALUE=http://www.webdeveloper.com/forum/archive/index.php/"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\xqweb\Bat3\ojt_new\ojtnews\OJTNEWS.mdb;">
Any one can kindly give me an advice?
<SCRIPT LANGUAGE=vbscript>
<!--
Sub FillVarietyList
Set R = VList.Recordset
Do Until R.Eof
Set O = document.createElement("OPTION")
O.Text = R(0)
VarietyList.add O
Set O = Nothing
R.MoveNext
Loop
VarietyList.disabled = false
End Sub
Sub window_onload
FillVarietyList
End Sub
-->
</SCRIPT>
<HTML>
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33" ID="VList" HEIGHT=1 WIDTH = 1>
<PARAM NAME="SQL" VALUE="SELECT ID FROM ADDNEWCOURSE">
<PARAM NAME="SERVER" VALUE="http://xiqing.sps.mot.com">
<PARAM NAME="CONNECT" VALUE="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\xqweb\Bat3\ojt_new\ojtnews\OJTNEWS.mdb;">
</OBJECT>
<SELECT ID="VarietyList" disabled></SELECT><P></BODY></HTML>
<PARAM NAME="CONNECT" VALUE=http://www.webdeveloper.com/forum/archive/index.php/"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\xqweb\Bat3\ojt_new\ojtnews\OJTNEWS.mdb;">
Any one can kindly give me an advice?
<SCRIPT LANGUAGE=vbscript>
<!--
Sub FillVarietyList
Set R = VList.Recordset
Do Until R.Eof
Set O = document.createElement("OPTION")
O.Text = R(0)
VarietyList.add O
Set O = Nothing
R.MoveNext
Loop
VarietyList.disabled = false
End Sub
Sub window_onload
FillVarietyList
End Sub
-->
</SCRIPT>
<HTML>
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33" ID="VList" HEIGHT=1 WIDTH = 1>
<PARAM NAME="SQL" VALUE="SELECT ID FROM ADDNEWCOURSE">
<PARAM NAME="SERVER" VALUE="http://xiqing.sps.mot.com">
<PARAM NAME="CONNECT" VALUE="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\xqweb\Bat3\ojt_new\ojtnews\OJTNEWS.mdb;">
</OBJECT>
<SELECT ID="VarietyList" disabled></SELECT><P></BODY></HTML>