SAS/ACCESS

[dataMart87]

What’s the difference between SAS/ACCESS Interface to Microsoft SQL Server and SAS/ACCESS Interface to ODBC?  I have ODBC’ed to a Microsoft SQL Server via SAS/ACCESS Interface to ODBC, but have not tried to ODBC to a Microsoft SQL Server via SAS/ACCESS Interface to Microsoft SQL Server.

[CTorres]

I understand that SAS/ACCESS Interface for Microsoft SQL Server is only available for UNIX and LINUX Operating Systems.

To access SQL Server in Windows Operating System you have to use SAS/ACCES to ODBC or OLE_DB.

[JBailey]

Hi @CTorres,

You are correct. It is worth mentioning that the SAS/ACCESS Interface to Microsoft SQL Server includes the DataDirect ODBC driver for UNIX/Linux. For Windows you would use ACCESS to ODBC and the ODBC driver that is included with Windows. Or OLE DB, as you point out above.