从采购订单审核后自动生成销售订单不能自动审核,错误如下:
解决方式为:需要在服务器中执行账套档案注册,账套档案设置等操作,否则在数据中连接字符串显示为客户端的机器名。
执行语句为:
updateHY_DZ_K7_REGISTsetconnstr="Provider=SQLOLED1;Password=Gi*5u2^nP;PersistSecurityInfo=True;UserID=sa;InitialCatalog=UFDATA_004_2020;DataSource=ERP-DATA01;CurrentLanguage=SimplifiedChinese;UseProcedureforPrepare=1;AutoTranslate=True;PacketSize=4096;WorkstationID=ERP-DATA01;UseEncryptionforData=False;Tagwithcolumncollationwhenpossible=False"whereaccid=1000000002
select*fromUFSystem..HY_DZ_K7_MAINACCProvider=SQLOLED1;Password=Gi*5u2^nP;PersistSecurityInfo=True;UserID=sa;InitialCatalog=UFDATA_001_2018;DataSource=ERP-DATA01;CurrentLanguage=SimplifiedChinese;UseProcedureforPrepare=1;AutoTranslate=True;PacketSize=4096;WorkstationID=SZNK2105157;UseEncryptionforData=False;Tagwithcolumncollationwhenpossible=False
updateUFSystem..HY_DZ_K7_MAINACCsetconnstr="Provider=SQLOLED1;Password=Gi*5u2^nP;PersistSecurityInfo=True;UserID=sa;InitialCatalog=UFDATA_001_2018;DataSource=ERP-DATA01;CurrentLanguage=SimplifiedChinese;UseProcedureforPrepare=1;AutoTranslate=True;PacketSize=4096;WorkstationID=ERP-DATA01;UseEncryptionforData=False;Tagwithcolumncollationwhenpossible=False"
文章为作者独立观点,不代表 股票程序化软件自动交易接口观点