3 Replies Latest reply on Jun 12, 2012 9:31 AM by paulsbird

    My ODBC Import is not functioning



      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 :-)