AnsweredAssumed Answered

My ODBC Import is not functioning

Question asked by paulsbird on Jun 11, 2012
Latest reply on Jun 12, 2012 by paulsbird


My ODBC Import is not functioning

Your post

HI All,
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 :-)