I am trying to simply update a flag in a table to say that I have integrated the integration works but the "After Script" Fails Wrong number of arguments or invalid property assigment"MyCon"
The database is on the GP SQL server but not a GP Database.
'Create a new connection object
Set MyCon = CreateObject("ADODB.Connection")
'Open the connection to the database
MyCon.ConnectionString = "database=Concur"
GPConnection.Open(MyCon)
sSQL = "Update concur.Cash_Amt set IntegrationFlag = '1' where Entity = 'SUS'"
'Execute the stored procedure
Call MyCon(sSQL)
It maybe a permissions thing as the database isn't a GP but any ideas would be appreciated.