I am in the need of some SQL and scripting help.
I have an external custom office script that creates a new sales order. It works great on the SQL server, but on the workstation.
Of course, I get a generic error 200.
I am login to the server and workstation as the same user.
The acct share and security are set to everyone full control
The server sota.ini file contains the following
DRIVER=SQL Server Native Client 10.0
The workstation sota.ini file contains the following
[MSSQL]
DRIVER=SQL Server Native Client 11.0
The massql.setting has the following information.
CONNECT='Driver={SQL Server Native Client 11.0}';
The company is set to allow external access
The server has both SQL Server Native Client 10.0 and 11.0 ODBC drivers loaded.
The workstation only has 11.0. I did try and find 10, but the download is not available anymore.
I am thinking it has to be something with network permissions or how MAS200 runs.
Any ideas would be appreciated.
Snipit of script
'Create ProvideX COM Object
Set oScript = CreateObject ("ProvideX.Script")
'The Init method must be the first method called
' Please remember to correct the MAS90\Home path
sPath = "\\FILESERVER\Acct\v2020\MAS90"
oScript.Init(sPath)
'The Session object must be the first MAS 90 object created
Set oSS = oScript.NewObject("SY_Session")
#SQL #custom office
------------------------------
Michael Davis
Warren Averett Technology Group
Birmingham, AL
------------------------------