Win 2003/SQL 2000 MDAC 2.8RTM db repair

From: Doug Little (DougLittle_at_discussions.microsoft.com)
Date: 01/26/05


Date: Tue, 25 Jan 2005 17:53:03 -0800

Hi,
I had an app install that screwed the MDAC install on a Win2003 Std Ed
server with SQL 2000 Std on it. And I can't seem to figure how to recover
it.
The problem shows when I try to use any of the enterprise mgr functions
(query designer, DTS designer). I get "error in dll" and "800401F9"

Component checker is looking for MDAC 2.8RTM files
ODBCBCP.dll v2000.85.1022.0
SQLSRV32.dll v2000.85.1022.0

I tried to run the MDAC_TYP to restore 2.8, but it's designed to do nothing
on 2003 and can't extract/ or catch the expanded files.
I found a security patch for sql 2000, but unfortunately it installed
2000.85.1025.0

Is there anyway I can fix the registry & Sql tools to use the ..1025
versions? or can someone tell me where to get/send me the ..1022. version

Thanks

-- 
Doug


Relevant Pages

  • Re: Installation of SQL on SBS 2003 Std
    ... One more question - SQL Ent can be installed on Win 2003 Std but not on SBS ... > machine as a member server and install the SQL Server 2000 Ent. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Cluster setup: Management Studio not installed on 2nd node...
    ... When I install SQL 2005 Std it only installs the SQL Management Studio and ... When I try to install the Management components on the 2nd node it tells ...
    (microsoft.public.sqlserver.setup)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)