RE: ODBC & SQLExecDirect

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ashish Ruparel [MSFT] (v-ashrup_at_online.microsoft.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 05:04:10 GMT

Hi Brandon,

There is a KB article that says that there is a bug in MDAC 2.6 and you
need to apply its latest service pack.
The KB Article is
http://support.microsoft.com/default.aspx?scid=kb;en-us;286359&Product=sql2k

The Service Pack for MDAC 2.6 can be obtained from
http://msdn.microsoft.com/data/default.aspx
On the right hand side, you will see and option of MDAC Downloads, select
MDAC 2.5 Service Pack 2.

Please apply latest service pack for SQL Server 2000, SP3, if you have not
done that so far.
SP3 for SQL Server 2000 for English Language can be obtained from
http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-
AFBF-ACACE5369FA3&displaylang=en

If you apply SQL Server 2000 SP3, you need not apply MDAC 2.6 SP 2, it will
be taken care of in SQL SP3.

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

Relevant Pages

  • RE: Timeout Expired on Successful database insert
    ... I would like to confirm my understanding of your issue. ... when doing an insert operation to SQL Server 2000 with ADO. ... Try to install the latest version of service pack and MDAC. ...
    (microsoft.public.data.ado)
  • Re: sp3 vs sp3a
    ... 3a includes MDAC 2.71a which fixed the memory leak issue ... 3a disables listening on UDP 1434 when all libraries ... except for shared memory are disabled. ... >>enables service pack upgrades for trial software. ...
    (microsoft.public.sqlserver.security)
  • Re: sp3a upgrade to developer edition
    ... You will need to run the service pack for all instances of SQL Server ... running and at a guess your Developer Edition is not the default instance. ... I believe the highest version of MDAC is 2.8. ... special upgrade for the DE? ...
    (microsoft.public.sqlserver.server)
  • RE: ODBC & SQLExecDirect
    ... We have MDAC 2.8 installed with service pack 3a. ... >Please apply latest service pack for SQL Server 2000, ... SP3, if you have not ...
    (microsoft.public.sqlserver.programming)
  • SQL Server and client MDAC versions
    ... Is it necessary or beneficial for the SQL Server and clients to be running ... SP3 and SQL Server 2000 SP3. ... The client makes a connection to SQL Server using MDAC. ...
    (microsoft.public.sqlserver.clients)