SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS/ACCESS

Reply
Contributor
Posts: 35

SAS/ACCESS

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.

Regular Contributor
Posts: 180

Re: SAS/ACCESS

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.

SAS Employee
Posts: 203

Re: SAS/ACCESS

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.

Ask a Question
Discussion stats
  • 2 replies
  • 336 views
  • 3 likes
  • 3 in conversation