請問各先進:
小弟使用RDS與IIS作連結結果傳出internet伺服器錯誤:找不到物件/模組;8209;請問我要如何解決?
程式如下
Dim rdso As New RDS.DataControl
Private Sub Command1_Click()
On Error GoTo e00
rdso.Server = "http://xxx.xxx.xxx.xxx"
rdso.Connect = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=d:\xxx\access\stock01.mdb"
rdso.SQL = "select * from aaa_data"
rdso.ExecuteOptions = adcExecSync
rdso.FetchOptions = adcFetchBackground
rdso.Refresh '--這裡發生error
Set rs = rdso.Recordset
Out rs
Exit Sub
e00:
MsgBox Err.Description, , Err.Number
End Sub
thank you.