Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Driver vs more recent ODBC driver
Message
From
20/11/2018 17:17:29
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Miscellaneous
Thread ID:
01663573
Message ID:
01663584
Views:
74
This message has been marked as a message which has helped to the initial question of the thread.
The current series of drivers for SQL Server outside of Visual Studio are labelled "ODBC Driver xx for SQL Server". The are described as being compatible with all prior versions of SQL Server. We have had no problems with 11, 13, 15 and the current one, 17.

They are also the drivers that are required for working with Always Encrypted on SQL Server, where the ODBC driver decrypts the data sent from the server.

Hank

>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform