目的:使用RDS访问远程Access数据库
情况,目前只是在安装了IIS上的服务器上调试,遇到以下问题,请教与该情况相关的IIS设置问题部分源码如下:在执行到 hisconn.refresh 时,提示 实时错误-2147012867 internet 客户端错误:不能连接服务器。
Dim HisConn As New RDS.DataControl
Dim HisRs As New ADODB.Recordset HisConn.Server = "http://127.0.0.1"
Connstr = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" _
& App.Path & "\Data\Now.mdb"
HisConn.Connect = Connstr HisConn.Sql = "select * from COM" & j & i
HisConn.ExecuteOptions = adcExecSync
HisConn.FetchOptions = adcFetchBackground
HisConn.Refresh
Set HisRs = HisConn.Recordset
多谢!
情况,目前只是在安装了IIS上的服务器上调试,遇到以下问题,请教与该情况相关的IIS设置问题部分源码如下:在执行到 hisconn.refresh 时,提示 实时错误-2147012867 internet 客户端错误:不能连接服务器。
Dim HisConn As New RDS.DataControl
Dim HisRs As New ADODB.Recordset HisConn.Server = "http://127.0.0.1"
Connstr = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" _
& App.Path & "\Data\Now.mdb"
HisConn.Connect = Connstr HisConn.Sql = "select * from COM" & j & i
HisConn.ExecuteOptions = adcExecSync
HisConn.FetchOptions = adcFetchBackground
HisConn.Refresh
Set HisRs = HisConn.Recordset
多谢!
请多指教!