FMSA - Connecting to external MS-SQL

[runlinux]

First off, here is my server setup:

Server 2008 R2 x64

FMSA v12.02.232

Now, onto the problem. I have a script step in my solution that connects to our sql server to import a record. I have FileMaker Pro Advanced installed on the server for testing purposes. I installed and setup the ODBC to connect and it works just fine in Pro Advanced. When I try to run the script as a schedule in Server Advanced, I get errors 401 and 802.

Any ideas?

[Wim Decorte]

import records from an ODBC source is not a server-compatible script step. You can tell by flipping your scriptmaker to "server" in the bottom left corner when you have the script open.

Your best bet is to use ESS and define your SQL Server table as an external data source. That way you can use it as just a regular FM table. You still won't be able to import from it but you will be able to loop and read the data. Depending on the amount of data, that may work.

[runlinux]

Thanks for that information!

Only issue I have to begin with is that I only have access to the data through a stored procedure. I'll play around with that and maybe I can link the tables I need.

I'll post back if I am still unable to figure it out.