>>Hi everybody,
>>
>>We're using SQL Server driver with our ODBC connection because of some issues.
>>
>>This driver seems to being deprecated and does't work for TLS 1.2.
>>
>>I forgot exact problems which led us to using this driver, can someone please summarize what are the problems with each of the driver and is there a workaround?
>>
>>We're using varchar(max) / varbinary(max) and text data types, but we're not using dates.
>>
>>Thanks in advance.
>
>What do you mean by SQL Server driver? Do you mean you are using driver={SQL Server}? The SQL Server 2000 driver which is already 18+ years old? Why not use {SQL Server Native client 11.0}? There are many problems using old driver.
>
>BTW text datatype is also going to be deprecated.

SQL Server native client 11.0 is not working correctly with varchar(max) column. I think that was the reason we used that driver. However, I think ODBC driver (the latest version) should work for us (it seems to be working correctly for varchar(max) and we're not using date columns, so we should be OK).