Running into an issue trying to get dbAMP working with Coldfusion. I have been using CF for a while now but have yet to have to use a stored procedure, i normally just query the tables etc. We decided to go with dbAMP to integrate our salesforce info and we got it installed and operatinf just fine in MS SQL. All our test stored procs work fine as well as the linked server.
So now comes the time when i want to extend the use and fire these stored procs from CF but cant seem to figure out how to to do it since dbAMP uses a linked server. The follow code snippet shows how I run a proc to pull down some Account info into SQL.
exec sf_refresh 'SALESFORCE' , 'Account'
Pretty simple the proc sf_refresh runs on the linked server SALESFORCE and targets the object Account.
My question is how would I fire this from coldfusion?
Thanks in advance for any help getting this going!