RE: ODBC & SQLExecDirect

From: Brandon (anonymous_at_discussions.microsoft.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 07:27:07 -0700

We have MDAC 2.8 installed with service pack 3a. Any other
ideas?

>-----Original Message-----
>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
    ... There is a KB article that says that there is a bug in MDAC 2.6 and you ... The Service Pack for MDAC 2.6 can be obtained from ... 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)
Quantcast