topic Re: List of supported drivers in Administration and Deployment

List of supported drivers

shoin — Thu, 07 Dec 2017 21:38:33 GMT

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,

Re: List of supported drivers

ChrisHemedinger — Thu, 07 Dec 2017 23:36:30 GMT

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.

Re: List of supported drivers

SASKiwi — Fri, 08 Dec 2017 01:18:37 GMT

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.

Re: List of supported drivers

shoin — Fri, 19 Jan 2018 21:45:54 GMT

Thank you all who took the time to reply. I was looking for a listing of current version of different ODBC drivers. Good points shared. I thank you!