topic Re: SAS/ACCESS in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS/m-p/150963#M2579 <HTML><HEAD></HEAD><BODY><P>Hi @CTorres,</P><P></P><P>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.</P></BODY></HTML> Fri, 31 Jan 2014 14:32:07 GMT JBailey 2014-01-31T14:32:07Z SAS/ACCESS https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS/m-p/150961#M2577 <HTML><HEAD></HEAD><BODY><P>What’s the difference between SAS/ACCESS Interface to Microsoft SQL Server and SAS/ACCESS Interface to ODBC?&nbsp; 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.</P></BODY></HTML> Thu, 23 Jan 2014 21:20:13 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS/m-p/150961#M2577 dataMart87 2014-01-23T21:20:13Z Re: SAS/ACCESS https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS/m-p/150962#M2578 <HTML><HEAD></HEAD><BODY><P>I understand that SAS/ACCESS Interface for Microsoft SQL Server is only available for UNIX and LINUX Operating Systems.</P><P>To access SQL Server in Windows Operating System you have to use SAS/ACCES to ODBC or OLE_DB.</P></BODY></HTML> Thu, 23 Jan 2014 21:41:36 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS/m-p/150962#M2578 CTorres 2014-01-23T21:41:36Z Re: SAS/ACCESS https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS/m-p/150963#M2579 <HTML><HEAD></HEAD><BODY><P>Hi @CTorres,</P><P></P><P>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.</P></BODY></HTML> Fri, 31 Jan 2014 14:32:07 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS/m-p/150963#M2579 JBailey 2014-01-31T14:32:07Z