Solved

MDAC = SQL Server Driver

Posted on 2013-10-31
3
525 Views
Last Modified: 2013-11-21
Take a look at the following image. Is the native "SQL Server" driver shown in the list equivalent to the old MDAC (Microsoft Data Access Components)?

SQL Server Driver
0
Comment
Question by:jdana
3 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 250 total points
ID: 39615404
No, it's supposed to replace it for both OLEDB and ODBC.  Here's a Microsoft article on the subject: http://msdn.microsoft.com/en-us/library/ms810810.aspx
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 250 total points
ID: 39615542
There is a newer SQL Native Client version 11 that you may want to use.
0
 

Author Closing Comment

by:jdana
ID: 39667507
Dave,

Great article. Thx.

TheHiTechCoach,

SQL Native Client is an terrific option. Thx.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question