Sage 100

v5.2 stabdard / Alerts & Workflows v8.3b. Just installed A&W.. Email tests fine. I created a System DSN and it tests successfully without entering logon information (logon info is hard coded in the dsn). I have a simple Crystal report that uses this system dsn as the data source. When I run the report outside of A&W it runs without any prompts for data or logon information. The report is set up to email a pdf from A&W. When it is scheduled to run from A&W the following message is displayed: ""Logon failed Details: Cannot find DSN in connection string"". Any ideas what is causing the report to fail?

Not that this has anything to do with your issue, but I show v8.3D as being the latest release....

Thanks Jeff. I just resolved the issue. A UNC path must be used in the ODBC DSN. I was using a mapped drive. Interesting, the A&W doc instructs to set up the System DSN exactly like the Sage user DSN except name it XXX_PVC instead of SOTAMAS90. if the workstation setup is performed correctly a mapped drive is always written to the user ODBC DSN.

Good point. Where ever possible, I always use a UNC path. Fewer quirky issues...