select c.* from viw_AssayRequestResults as c inner join " & _
"openrowset('MSDASQL','DRIVER={SQL Server};SERVER=192.168.8.71;UID=sa;PWD=dfdf;database=sdf'" & _
",'select * from mydatabase.dbo.ChildOptFee where FeeFlag<>0 and dateadd(day,3,RegDate)>=getDate()') as o " & _
"on c.儿童编号=o.childcode and c.申请日期=o.OptDate事实错误-2147217900
已拒绝对 OLE DB 提供程序 'MSDASQL' 的特殊访问。必须通过链接服务器来访问此提供程序。
"openrowset('MSDASQL','DRIVER={SQL Server};SERVER=192.168.8.71;UID=sa;PWD=dfdf;database=sdf'" & _
",'select * from mydatabase.dbo.ChildOptFee where FeeFlag<>0 and dateadd(day,3,RegDate)>=getDate()') as o " & _
"on c.儿童编号=o.childcode and c.申请日期=o.OptDate事实错误-2147217900
已拒绝对 OLE DB 提供程序 'MSDASQL' 的特殊访问。必须通过链接服务器来访问此提供程序。
"openrowset('SQLOLEDB','192.168.8.71';'sa';'tjgongtryhealthsystem'" & _
",'select * from mydatabase.dbo.ChildOptFee where FeeFlag<>0 and dateadd(day,3,RegDate)>=getDate()') as o " & _
"on c.儿童编号=o.childcode and c.申请日期=o.OptDate[OLE/DB provider returned message: 无法完成延迟准备。]