碰到这样一个问题,在循环中执行如下代码的时:
rsSignCard.Open "Select workofftype from #signcard Where workofftype is not null and sign_data=" & rsTemp!mem_id & " and adate='" & rsTemp!adate & "'", cnDatabase, adOpenForwardOnly, adLockReadOnly
会偶尔出现这个错误:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问,抓到错误之后,再resume执行此代码,又可以正常执行通过;请教这是什么原因?
rsSignCard.Open "Select workofftype from #signcard Where workofftype is not null and sign_data=" & rsTemp!mem_id & " and adate='" & rsTemp!adate & "'", cnDatabase, adOpenForwardOnly, adLockReadOnly
会偶尔出现这个错误:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问,抓到错误之后,再resume执行此代码,又可以正常执行通过;请教这是什么原因?
这样处理:
if rsSignCard.state=1 then rsSignCard.close
rsSignCard.Open "Select workofftype from #signcard Where workofftype is not null and sign_data=" & rsTemp!mem_id & " and adate='" & rsTemp!adate & "'", cnDatabase, adOpenForwardOnly, adLockReadOnly
2,在SQL所在机器安装SQL的最新补丁
3,在SQL所在的机器关闭防火墙,包括windows自带的防火墙