Call Remote Procedures

0 votes

Is it possible to call a remote stored procedure via a button if the remote server is a linked server?

in How To by (360 points)
recategorized by
Moved from a feature request to a HowTo

1 Answer

0 votes
Best answer

dbFront has no knowledge of linked servers or procedures.

I would attempt call the remote procedure from a local procedure.

by (64.3k points)
selected by
Ok, interesting work around. Additional question - is there a way to allow the user to input data that arent part of the table? Example -  I want to create a button that runs a stored procedure that moves data from one server to another server (linked). I would like the user to be able to input the Source and Destination. Im assuming I'd have to add Source/Destination columns to the  table?
The ability for custom ActionButtons to prompt users for additional information was added in dbFront   See:
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer