Hi Everyone,
when connecting to our Microsoft SQL Database via "SAS/ACCESS Interface to Microsoft SQL", SAS uses the installed Progress DataDirect Microsoft SQL Server Wire Protocol ODBC driver component. (https://www.progress.com/odbc/microsoft-sql-server)
![odbc_driver_32_bit.JPG odbc_driver_32_bit.JPG](https://communities.sas.com/t5/image/serverpage/image-id/41193i05B9C19D2A12A88C/image-size/large?v=v2&px=999)
![Driver_Details.JPG Driver_Details.JPG](https://communities.sas.com/t5/image/serverpage/image-id/41581iAE6C44206F291071/image-size/large?v=v2&px=999)
I noticed, that the "S0SQLS27.DLL" being used, is dated Novermber 21st, 2018.
So my first question would be:
Is this still the up-to-date-driver, I should use?
And the other question is:
why is a 32 bit driver used, even though, I am running SAS on Windows 2016 Server 64bit?
This is, how the odbc.ini looks:
![ODBC-drivers_ini.JPG ODBC-drivers_ini.JPG](https://communities.sas.com/t5/image/serverpage/image-id/41587i4D4BAEDE5C4D7DED/image-size/large?v=v2&px=999)
Thx,
FK