Hi, I'm trying to import ODBC tables (from a VisualFoxPro database) into my database located on a FileMaker Server. The ODBC source / DSN are located on the same computer as my Server. The trouble is, when I try to import the tables, either from the File menu or by setting up a script, I can only choose my LOCAL DSNs, not the ones setup on the server. Any suggestions?
I am eventually going to want to to server-scheduled scripts, but this task is more specifically about having a user activate a script that will run an import from the ODBC source to the Filemaker database, all on the server side. And since the source is VisualFoxPro, a live External Data Source is not an option
Thanks for any help!