I ran into problems with SQL Server script execution from FB when the scripts referenced linked servers. The query was throwing the above message. I was able to fix it by adding SET statements to the scripts, and thought I was all set. It came up again, however, when I tried executing Stored Procs with linked servers, and was much more difficult to solve.
After 20 minutes of mucking around with the placement of the SET statements without too much success I punted and tried using the OSQL library instead of ISQL, which worked. I was unable to find any specific references to this issue on these forumns, and wondered if this is the best way to solve the problem, or if there is a more elegant solution.
Hi David,
Sorry - can’t help you there… and thanks for posting the solution.
.t8