A "CLI execute" error occurs when you run the SAS/ACCESS® Interface to PC Files Server as a stored process


In applications such as SAS® Enterprise Guide®, the following error can occur when you run a stored process with code that uses the SAS PC Files Server:

ERROR: CLI execute error: [Microsoft][ODBC Excel Driver]

The problem occurs under the following circumstances:

The problem occurs because the stored process runs as a batch process, and the local machine cannot resolve the server and port in this mode. The same code runs successfully on the workspace server.

To circumvent the problem, add the SERVER= and PORT= options to your code to enable the PC Files Server to find the correct server and port.