01-23-2014 04:20 PM
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.
01-23-2014 04:41 PM
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.
01-31-2014 09:32 AM
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.