I'm getting the same issue with an access database that I'm using for an external lookup. The database is password protected however I entered the password into the model and all works fine. It is failing when I run it through the automator process with the same exact error message. I do not see a place to enter the password in Datawatch server dashboard for either the process, model, or project. Am I missing something?
In DSAdmin on AUTOMATOR , you can enter the password by going to :
Automator Menu / Standard Processes /
You click on your process
In the " Project File Paths " , you click on the " Open in Editor project "
You will in the "Input" tab
"DataBase" must be checked.
"Include password" must be checked.
Your password must be entered.
For our problem, I opened a support ticket , with whom I exchanged via WebEx. The technician sees no solution yet , it must reproduce the case on its side before I return to correct
Thank you for the reply!
You response was appropriate for a database connection but not for an external lookup with was the password protected database. I found the answer to my problem by going to Options in Modeler and changing a setting for it to save the external lookup password with the project\model.
Good luck with your issue!
Frank Walka | Assistant Vice President
Business Process Analyst
5716 Berkshire Valley Road
Oak Ridge, NJ 07438
973-935-7223 ext. 884274