DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
smartstream 1/15/2015 12:14:26 PM

Integration Manager writeback to a NON GP database

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.

 

Version: GP 2013
Section: Integration Manager