Does Execute SQL script step work in a script run via Perform Script on Server?

Discussion created by tananatim on Oct 17, 2014
Latest reply on Oct 21, 2014 by tananatim

On my FileMaker 12 Server, I have an ODBC data source referencing a SQL Server 2005 database. It successfully connects to the database. If I run a script on my FileMaker client app, which is hosted on the FileMaker server, that in turn executes another script via Perform Script on Server that contains an Execute SQL step, will it work? I understand from postings here that Execute SQL doesn't use the server ODBC data source, but it wasn't clear if that applied also to scripts performed on the server.