12-07-2017 04:38 PM
Hello all. Is there a listing that shows latest supported driver versions (for ACCESS/ODBC at least)? For example, what is the latest MS SQL SRVR driver version supported by SAS (use with ACCESS/ODBC)?
So far my search has failed.
Thank you in advance,
12-07-2017 06:36 PM
As far as I know, the functioning of SAS/ACCESS to ODBC is not that sensitive to driver versions. At least, not to the point that there would be an exhaustive list of drivers/versions supported. That's kind of the point of ODBC -- it's a protocol that if complied with, it should just work. I would hope that the most recent SQL Server driver (13.1, I think) should be okay.
You might need a specific driver version to support a proper connection/feature to a specific version of your database (ex: specific driver for some feature in Oracle 12c), but the SAS/ACCESS part should work with whatever driver you have making that connection.
Are you looking at Azure-hosted data? Might be some special considerations -- post back with specific questions if you run into challenges.
With SAS on Windows, you do need the bitness to match -- 64-bit SAS needs to use the 64-bit version of an ODBC driver.
12-07-2017 08:18 PM
Please be aware that different versions of ODBC drivers may not behave exactly the same. I would recommend rigorously testing new drivers prior to rolling them out.