My ODBC Import is not functioning
I setup a script to do a daily import from an ODBC source. The script works fine when I am in the filemaker pro client, but when my server script runs at night, it is not importing the data from the source.
The message in the log file is a scripting error (3)
My System DSN on the server is connecting to a SQLEXPRESS INSTANCE
The SQL Server is verifying the login authenticity with Integrated Windows authentication (no SPN is entered)
The filemaker service is running under an account with Admin privileges on both the filemaker server machine and the SQL server machine.
Any input is greatly appreciated, well input pertaining to the specified issue :-)