I have a VB script on an application server to open an .xlsm, and run a function which does the following:
  1. Open an Excel file with a OLEDB connection
  2. Refresh the connection
  3. Save and close

When running manually, everything works as designed. However, when running in Task Scheduler as a specific user whether logged in or not (with password and highest priv, also both folders are on the server).

From my simple logging method, I can tell that it's failing on the "Refresh" step
Please Login or Register  to view this content.
In the data source settings, I'm using database credentials, and am passing through the UID/PWD through the connection string.

Any help/advice you all could provide would be greatly appreciated.

d6ssm.png

rnO72.png

kFb6A.png