I know that this may not be a NT question, but…
I have the MS Access database and a macro inside that connects to a couple of other access databases and then connects to Oracle through ODBC. I have a REXX exec written to execute the macro which runs from the command prompt on the server. I can execute the macro from inside the access database and it runs fine wing both the REXX exec and executing the macro directly. However, when I schedule the REXX exec thru AT, I get an ODBC error, 3151ODBC Connection Error.
The Oracle Client is installed and ODBC is setup correctly. I even checked the path statements and they look right.
Does anyone have any suggestions?