An Idea Exchange for SAS software and services

Comments
by Trusted Advisor
on ‎02-23-2018 03:24 AM

Hello @tomrvincent,

 

perhaps I am not understanding you, could you please elaborate your idea?

 

Reason is that, as far as I am concerned, read and write access to ODBC data sources is available as long as is configured on the SAS connection, the ODBC connection and the user of the connection has the permissions to the databases.

by Regular Contributor
on ‎02-23-2018 09:27 AM

If I try to read Access or SQL Server on Linux, I get a misleading error message: ERROR: DBMS type ACCESS not valid for import.

But Access IS valid for import.  This is what I got from SAS tech support:

In the notes from this track I see you are running SAS on a Linux system.
In this case the DBMS of ACCESS and EXCEL will be unavailable.
This is due to their reliance on the Microsoft drivers for their interaction with the end file.
In this case the options are limited when working with MS Access database files.
The use of the PC Files Server will be the only solution that would allow a Linux based install to interact with Access.

 

Now, there ARE ODBC equivalents for Linux and SAS should utilize them for accessing Access and SQL Server.

by SAS Employee JBailey
3 weeks ago

Hi @tomrvincent

 

Are you talking about Microsoft Access?

 

Best wishes,

Jeff

by Regular Contributor
3 weeks ago

Yes.

by SAS Employee JBailey
3 weeks ago

Hi @tomrvincent

 

Are you using a SAS/ACCESS Interface or are you using something else (import wizard, EG, etc.)?

 

Best wishes,
Jeff

by Regular Contributor
3 weeks ago

Import or export within EG.

Idea Statuses
Top Liked Authors