topic Error Message for a libname in SAS Enterprise Guide

Error Message for a libname

lovedieer — Tue, 12 Apr 2016 18:54:59 GMT

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.

Re: Error Message for a libname

Reeza — Tue, 12 Apr 2016 19:04:09 GMT

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";

Re: Error Message for a libname

Haikuo — Tue, 12 Apr 2016 19:07:37 GMT

Darn 64bit? we had the same issue before, so give a try to see if it fits yours.

Re: Error Message for a libname

SASKiwi — Tue, 12 Apr 2016 19:39:44 GMT

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.

Re: Error Message for a libname

lovedieer — Wed, 13 Apr 2016 12:01:25 GMT

Thank you all for the solution. I will contact IT department to check the suggestion. we are not allowed to change anything on computer, even minor as adobe reader updating. Thank you all.