Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
montu
Yak Posting Veteran
60 Posts |
 Posted - 2008-01-02 : 22:03:29
|
| Hi Allmay be my post sounds stupid but i have on idea about it.can some one there please clear what is relationship between MDAC and SQL Server. id MDAC part of SQL Server or it is optional tool for some thing else. what it is excatly and links to useful tutorial etc. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-02 : 22:30:32
|
| MDAC is a collection of 'data access components'. These allow you to connect to just about all microsoft (and some non-microsoft) based data stores.MDAC 2.8 sp1 was the last to be released. Apparently, it is now a componenent of the OS and is now called Windows DAC in vista. Since there were problems with updating MDAC when running SQL 7 and SQL 2000, microsoft created a new component called the SQL Native Client that only contains odbc/ole db components for accessing SQL Server. SQL Native Client shipped with SQL Server 2005.read more about mdac here http://en.wikipedia.org/wiki/MDAC-ec |
 |
|
|
|
|
|
link between SQL and MDAC