If you are using FileMaker Server and not FileMaker Server Advanced, ODBC is not supported from the server.
Sorry for the ambiguity. I am using FM Server Advanced.
Can anyone help with this ODBC issue?
* Bump *
I just moved my FM13 Advanced server to a Virtual Windows 2012 Server and now have this exact problem, where a scheduled script will not import from an external ODBC. I am running 13 v5 and the latest ODBC drivers as well. I have verified that I can access the ODBC via another program, so I know the link is up.
I have followed the advice on Answer ID: 11080 which is to address this exact problem to no avail.
Any help is appreciated.
**** EDIT: I can't be 100% sure it's Advanced server, though my license is for advanced server and every other install I've done is Advanced. I can't find any place that shows whether you are running regular or advanced. How do you tell? ****