11 Replies Latest reply on Feb 17, 2012 10:05 AM by philmee95

    ODBC username / password problems with scheduled import script

    n/a

      Title

      ODBC username / password problems with scheduled import script

      Your post

      Short Version of Question:

      • How do I automate the input of username/password for an odbc connection that is being accessed by a scheduled script?

      Full Version of Question:

      • I am running FMP10 server on a windows server box and am using an ODBC connection to import records from an external SQL server.  I have established the connection and written a nice script to import records from this connection and everything works fine when I run the script myself.  The problem is that I want to automate this script using the servers schedule function. I have scheduled the script to run each morning but the problem is that the script aborts because I am not there to manually enter the Username and Password for the ODBC connecttion. Every time the script is run, I am prompted to enter this username and password for the ODBC connection and I am wondering if there is any workaround available?  

      I have already searched the forums to no availe.  If this has been addressed already, I apologize.  Any assistance would be greatly appreciated.  Thank you in advance for any help.