1、从采购订单审核后自动生成销售订单不能自动审核,错误如下:
解决方式为:需要在服务器中执行账套档案注册,账套档案设置等操作,否则在数据中连接字符串显示为客户端的机器名。
后台查询表为:HY_DZ_K7_REGIST,UFSystem..HY_DZ_K7_MAINACC
执行语句为:
select * from HY_DZ_K7_REGIST
update HY_DZ_K7_REGIST set connstr = 'Provider=SQLOLEDB.1;Password=Gi*5u2^nP;Persist Security Info=True;User ID=sa;Initial Catalog=UFDATA_004_2020;Data Source=ERP-DATA01;Current Language=Simplified Chinese;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ERP-DATA01;Use Encryption for Data=False;Tag with column collation when possible=False'
where accid = 1000000002
select * from UFSystem..HY_DZ_K7_MAINACC
Provider=SQLOLEDB.1;Password=Gi*5u2^nP;Persist Security Info=True;User ID=sa;Initial Catalog=UFDATA_001_2018;Data Source=ERP-DATA01;Current Language=Simplified Chinese;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SZNK2105157;Use Encryption for Data=False;Tag with column collation when possible=False
update UFSystem..HY_DZ_K7_MAINACC set connstr = 'Provider=SQLOLEDB.1;Password=Gi*5u2^nP;Persist Security Info=True;User ID=sa;Initial Catalog=UFDATA_001_2018;Data Source=ERP-DATA01;Current Language=Simplified Chinese;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ERP-DATA01;Use Encryption for Data=False;Tag with column collation when possible=False'