Rx_
Nothing In Moderation
- Local time
- Today, 13:21
- Joined
- Oct 22, 2009
- Messages
- 2,803
Don't Panic
(Large Friendly Letters)
A re-post of a news item.
As a promoter of the SQL Server Native Client, I wanted to post this and ask anyone if they have encountered this issue?
It appears that the older SQL Server Native Client will break after this SQL Server update is installed. There was no indication of the standard ODBC having this issue.
For myself, I use the latest SQL Server Native Client 11.0. We have not had the problem appear.
If anyone else is doing this, it wouldn't hurt to weigh in.
I have added a Poll for those who use SQL Server Linked Tables
(Large Friendly Letters)
A re-post of a news item.
As a promoter of the SQL Server Native Client, I wanted to post this and ask anyone if they have encountered this issue?
It appears that the older SQL Server Native Client will break after this SQL Server update is installed. There was no indication of the standard ODBC having this issue.
For myself, I use the latest SQL Server Native Client 11.0. We have not had the problem appear.
If anyone else is doing this, it wouldn't hurt to weigh in.
I have added a Poll for those who use SQL Server Linked Tables
Code:
[COLOR=#555555]Posted: 20 Nov 2014 07:41 PM PST[/COLOR]
[COLOR=#000000]My inbox has been flooded by [URL="http://www.infoworld.com/article/2848574/operating-systems/microsoft-botches-kb-2992611-schannel-patch-tls-alert-code-40-slow-sql-server-block-iis-sites.html"]reports[/URL] around the world of Access suddenly being slow or unusable after the latest set of patches issued by Microsoft.
Turns out one of the patches for SQL Server will in effect render Access applications using the native SQL Server drivers in Windows useless as reported here by [URL="http://darrenmyher.wordpress.com/2014/11/13/security-update-ms14-066-causes-major-performance-in-microsoft-access-sql-server-applications/"]Darren Myher.[/URL]
None of our client applications were affected since we have long migrated all of our clients to SQL Native Client 10 and more recently SQL Native Client 11.
For an example on how to use the native client please refer to this [URL="https://accessexperts.com/blog/2011/03/24/sql-server-connections-strings-for-microsoft-access/"]post.[/URL]
The only drawback to using the client is that it requires installation of either the 32 bit or 64 bit of the driver on every PC using the application. (Select 32 or 64 based on the version of your Windows OS and NOT the version of your Office Suite).
Here are the download links to Client 11:
[URL]http://www.microsoft.com/en-us/download/details.aspx?id=36434[/URL]
Downloading Native Client 10 is a little more complex, first navigate to this page:
[URL]http://www.microsoft.com/en-us/download/details.aspx?id=16978[/URL]
Click on the plus sign next to [B]Install Instructions[/B]
Navigate down the long page to the section titled
[B]Microsoft® SQL Server® 2008 R2 Native Client[/B]
[/COLOR]