BookmarkSubscribeRSS Feed
irgsocoll
Calcite | Level 5

I'm having a bit of trouble with SAS EG exporting to an Access database.  I'm running 64-bit Windows, 64-bit SAS EG 5.1, and 64-bit Office.  I've downloaded the PC File Server, and if I load up some bogus data into base SAS 9.3 (32-bit), I can export that data using the exact same code.  I've found that some people have problems when they have an HP printer as their default printer; I don't, but I still switched my printer and still get the same error.  I've updated my Microsoft Access Database Engine.  So I'm sort of at a loss for what's going on.

PROC EXPORT data=work.rejh

OUTTABLE="COHORT"

DBMS =  ACCESSCS

REPLACE;

DATABASE="\\...\FF_COHORT.accdb";

RUN;

I've also tried DBMS=ACCESS.  Each time, I get "Connection Failed.  See log for details."  Of course, there aren't any details.

Any ideas?

3 REPLIES 3
ChrisHemedinger
Community Manager

If the SAS session is on a remote Windows machine, then you might be running into a delegation issue.  That's where your local connection to a Windows server won't let you access another network resource (such as a network folder) because the credentials don't propagate to the "second hop".

See the SAS notes about "Trusted for Delegation".  Here's one:

41477 - Authorization errors can occur in SAS® Enterprise Guide® when you use Integrated Windows Aut...

To fix, you'll need the help of an admin who can make a change in Active Directory for you.

Chris

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
JRebo
Calcite | Level 5

Where you able to find a fix because I'm having the same issue?  Our code is working fine on the WindowsXP machines but we get this error when we were upgraded to Windows7 (64-bit)? 

SASKiwi
PROC Star

DBMS =  ACCESSCS requires the PC File Server to be installed and running. Is it still running with Windows 7?

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 3393 views
  • 0 likes
  • 4 in conversation