04-12-2016 02:54 PM
I used to use the below code to connect to one of our ACCESS database at sharedrive.
libname LOC access "\\...share\data\database.accdb";
however, we recently updated the SAS EG, and my code do not work any more, and it gave me below error message:
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
same error message also happened to my proc export/ import procedure. i have to using import/export wizard to import or export my thousands external files weekly. But i still can use the libname statement to assign a permanent library on my share drive.
I used proc setinit to check our SAS module, and we do have the SAS/ACCESS interface to PC Files module. our IT has no idea what happened. your response will be appreciated. Thank you.
04-12-2016 03:04 PM
You likely upgraded to a version of SAS that is 64bit and your office is 32 bit.
See if you have PC file server installed. If so, start it up and use one of the following:
libname LOC pcfiles path= "\\...share\data\database.accdb"; libname LOC accessCS "\\...share\data\database.accdb";
04-12-2016 03:39 PM
An alternative solution to using the PC File Server to deal with the bitness problem is to install the 64-bit Microsoft ACE Database drivers as long as your SAS Server is Windows-based. These are available as a download from Microsoft.
04-13-2016 08:01 AM