BookmarkSubscribeRSS Feed
0 Likes

We should be able to read and write Access using ODBC or some equivalent on Linux.  There are other ODBC drivers available for Linux for other products.

6 Comments
JuanS_OCS
Amethyst | Level 16

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.

tomrvincent
Rhodochrosite | Level 12

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.

JBailey
Barite | Level 11

Hi @tomrvincent

 

Are you talking about Microsoft Access?

 

Best wishes,

Jeff

tomrvincent
Rhodochrosite | Level 12

Yes.

JBailey
Barite | Level 11

Hi @tomrvincent

 

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

 

Best wishes,
Jeff

tomrvincent
Rhodochrosite | Level 12

Import or export within EG.