BookmarkSubscribeRSS Feed
whileman
Fluorite | Level 6

My issue sounds like a catch 22.  My SAS user is trying to link from MS Access to a SAS dataset.  Currently, the SAS ODBC drivers are only installed on the SAS servers---where MS Access is not installed.  Is there a way for the local PC to access the SAS drivers installed on the SAS server through the ODBC Data Source Administrator?  Is it possible to download and install the SAS ODBC drivers on the SAS user's PC?  Thanks!

 

 

4 REPLIES 4
Reeza
Super User

@whileman wrote:

 Is it possible to download and install the SAS ODBC drivers on the SAS user's PC?  Thanks!

 


Yes, this is possible:

https://support.sas.com/downloads/browse.htm?cat=40

whileman
Fluorite | Level 6

thanks so much reeza.  ended up downloading both the 32-bit and 64-bit, after the 64-bit resulted in a ODBC - call failed.  Get the same error with the 32-bit ODBC driver anyway:  [Microsoft]{ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0).  Any ideas? 

Reeza
Super User

I'd probably contact SAS tech support. 

But what bitness is SAS and what is MSAccess? Are they the same or different? If different you may need PC FILE SERVER but not sure how that works with ODBC. 

whileman
Fluorite | Level 6

You must've been reading my mind.  Just submitted track. EG and MSAccess are both 32-bit to avoid the need for PC File Server or at least that's how I understand it. Will let you know what TS tells me.  Thanks again for your assistance...wayne 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1331 views
  • 2 likes
  • 2 in conversation