topic Re: Linking MS Access to SAS Datasets in Administration and Deployment

Linking MS Access to SAS Datasets

whileman — Tue, 13 Feb 2018 16:22:01 GMT

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!

Re: Linking MS Access to SAS Datasets

Reeza — Tue, 13 Feb 2018 16:26:51 GMT

@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

Re: Linking MS Access to SAS Datasets

whileman — Tue, 13 Feb 2018 19:08:26 GMT

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?

Re: Linking MS Access to SAS Datasets

Reeza — Tue, 13 Feb 2018 19:25:28 GMT

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.

Re: Linking MS Access to SAS Datasets

whileman — Tue, 13 Feb 2018 20:25:01 GMT

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