Re: Version of MDAC for SQL 2005?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Really you should be using the new SQL Native Client or the
Servers\Setup\sqlncli.msi

The minimum version for named instances is 2.71. I would recommend the
latest MDAC 2.8 SP1.

Check out this blog about SQL Native Client.
http://blogs.msdn.com/dataaccess/archive/2005/04/26/412161.aspx

There's a programming guide here too:
http://msdn2.microsoft.com/en-us/library/ms130892.aspx

--
Brad Sarsfield [MSFT] bradsa(at)microsoft.com

This posting is provided "AS IS", with no warranties, and confers no rights.



"Randy K" <wawork@xxxxxxxxxxx> wrote in message
news:4366b420.29105906@xxxxxxxxxxxxxxxxxxxxxxx
> With SQL Serve 2005 what version of MDAC is needed for named
> instances? Anything else need upgrading? Thanks.


.

Relevant Pages

  • RE: SQLPutData against MSSQL view
    ... column with MDAC; however you could do that with SQL Native Client. ... If I have misunderstood, please let me know. ... SQL Native Client can support varchar, ...
    (microsoft.public.sqlserver.odbc)
  • RE: Linked Server and Server Registration
    ... It may have to do with your MDAC version. ... Can you make an OSQL connection ... from the SQL7 box to the SQL2K box? ... because older versions of MDAC don't know about named instances. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO and SQL2005
    ... Paul wrote: ... The MDAC isn't changed at all. ... They only installed the new SQL Native Client 2005. ... installation which can not handle correctly SQL 2005. ...
    (borland.public.delphi.database.ado)
  • RE: Upsizing Access 2000 to SQL Server 2000
    ... It might be related to your MDAC version, ... recognize named instances. ... Cannot Connect to Instance of SQL Server 2000 ... Cindy Gross, MCDBA, MCSE ...
    (microsoft.public.sqlserver.connect)
  • Re: NT4 client connecting to SQL2000 named instance
    ... You need to be using at least MDAC ... to connect to named instances. ... connection is fine, can ping to the SQL Server. ... Connecting by TCP/IP network ...
    (microsoft.public.sqlserver.clients)