BookmarkSubscribeRSS Feed
dataMart87
Quartz | Level 8

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.

2 REPLIES 2
CTorres
Quartz | Level 8

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
Barite | Level 11

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.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1208 views
  • 3 likes
  • 3 in conversation