I've been regularly able to export a SAS dataset into an Access database located on our local network from SAS Viya using PC file server. However, now I'm getting the following error messages when I export the usual SAS dataset (MYDATA):
"ERROR: CLI disconnect failed: Server communication failure."
"ERROR: Error in the LIBNAME statement."
The strange thing is I can successfully export sashelp.class into the same Access database without error. Originally I thought the issue was that I converted string into numeric and it wasn't able to overwrite the Access table with different data types for the same column names but I compared the proc contents from the exported dataset to the imported dataset and variable types aligned. Also, I'm not able to export MYDATA into a new table (i.e., no overwrite) in the Access database like I was able to do with sashelp.class. Meaning the issue appears to have something to do with MYDATA. The only change to MYDATA from working to not working was new records and some new values in existing records, but I'm not sure how to investigate the problem here. Any ideas?
Can you please post the complete SAS log of your program, not just the errors. Also please post the complete SAS log of the export that works.
This SAS Note is a close match: https://support.sas.com/kb/46/541.html
Check what version of the MS Access Database Engine you have installed on your SAS PC Files Server. Going to a more recent version may help. We started trying the 2016 version recently and haven't had any problems although we weren't using it with the SAS PC Files Server.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.