Menu

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 (350 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 (44.5k 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 1.0.11.0052.   See: https://dbfront.com/qa/207/allow-a-button-to-prompt-for-additional-information
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
...