Re: Install SQL server 2000

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

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/24/04


Date: Wed, 24 Nov 2004 08:59:29 -0700

Sorry to hear that Lionel...that would be very frustrating.
Incomplete installs are generally caused by running an MDAC
update while some of the MDAC dlls are in use.
Try running component checker against the expected version
of MDAC 2.8 SP1 on Windows XP SP2
It's the second option when you run and then select this
version in the drop down.
Then check if the mismatch fields column is populated for
various components. Sometimes you have to manually replace
the appropriate files but you'd want to be very careful when
doing this and make sure you are copying the correct files
over to the box. You may also find the following article
useful:
How To MDAC Setup Troubleshooting Guide
http://support.microsoft.com/kb/232060
-Sue

On Tue, 23 Nov 2004 23:59:02 -0800, Lionel
<Lionel@discussions.microsoft.com> wrote:

>With XP SP2, the version is the last one : 2.8
>
>The other problem is in the register : all de ODBC keys are disapeared.
>SOFTWARE\ODBC\ODBC.INI\ : all my drivers are deleted but not the dll files
>in the System32 directorie. It's like MDAC was partially deleted. Windows SP
>2 get lost completly. I'm furious!!
>
>"Sue Hoegemeier" wrote:
>
>> It won't let you install if you try to install the same or a
>> lower version. Run the component checker to see what version
>> is currently installed and to see if there are issues with
>> your MDAC installation. You can use the tool to fix a bad
>> installation. Or you'd have to try installing a higher
>> version then what you already have. In either case, you'd
>> want to run the component checker to check the current
>> version and to check for issues.
>>
>> -Sue
>>
>> On Tue, 23 Nov 2004 09:23:49 -0800, Lionel
>> <Lionel@discussions.microsoft.com> wrote:
>>
>> >Hello
>> >
>> >But I can't install MDAC because the setup program says MDAC is allready in
>> >Windows XP pro. I can just cancel.
>> >
>> >Lionel
>> >
>> >"Sue Hoegemeier" wrote:
>> >
>> >> MDAC installation (which have the ODBC drivers) can be
>> >> impacted by many things - installs and uninstalls, service
>> >> packs, etc. The drivers could have gotten out of sync or the
>> >> MDAC configuration is messed up. You can check your MDAC
>> >> installation with component check. You can install the
>> >> latest MDAC version. You can find MDAC versions and the
>> >> component checker at:
>> >> http://msdn.microsoft.com/data/mdac/default.aspx
>> >>
>> >> -Sue
>> >>
>> >> On Tue, 23 Nov 2004 08:41:02 -0800, Lionel
>> >> <Lionel@discussions.microsoft.com> wrote:
>> >>
>> >> >JD,
>> >> >
>> >> >Witch driver you're talking. I install SQL server, so SQL server must
>> >> >install its own ODBC driver ? I've allready install SQL server and I've never
>> >> >installed any other ODBC driver.
>> >> >
>> >> >Lionel
>> >> >
>> >> >"JD" wrote:
>> >> >
>> >> >> Lionel,
>> >> >> Sounds like you are missing your ODBC drivers. Verify that you still
>> >> >> have ODBC installed on your computer. Then go to www.microsoft.com and down
>> >> >> load the ODBC drivers that you need.
>> >> >>
>> >> >> hth
>> >> >>
>> >> >>
>> >> >> "Lionel" <Lionel@discussions.microsoft.com> wrote in message
>> >> >> news:185AC50F-7214-4370-BBAE-43D7AAB7BE81@microsoft.com...
>> >> >> > Hello
>> >> >> >
>> >> >> > I've SQL Server 2K on windows XP and it was run correctly. I uninstall
>> >> >> > visual studio .net 2002 and then SQL server doesn't run any more (pb when
>> >> >> > connecting with entreprise manager : DMO can't find the server ? but not
>> >> >> with
>> >> >> > query analyser). So I uninstall sql server and install it again. But I
>> >> >> can't
>> >> >> > because when the install program wants to connect to SQL Server with ODBC
>> >> >> > driver, there's an error : data source not found and driver unknown. And
>> >> >> it's
>> >> >> > stop.
>> >> >> >
>> >> >> > What can I do to install SQL serevr 2000 on my windows XP pro.
>> >> >> >
>> >> >> > Thank you
>> >> >> > Lionel
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>



Relevant Pages

  • Re: ADO Error 430 (automation) on some machines
    ... ran component checker and it looks just the same as on all the other ... machines having MDAC 2.8 installed. ... >> Now I tried to install exactly the same MDAC version, ... >> rights. ...
    (microsoft.public.data.ado)
  • RE: MDAC 2.8 uninstall
    ... Have you tried to run the Component Checker from the run line with the /d ... to uninstall mdac and install the version you specified. ... the /NR switch along with the /d switch it will not install what ever mdac ...
    (microsoft.public.win2000.setup_deployment)
  • Re: MSDAC 2.8 on terminal server
    ... > MDAC 2.8 on each session of the server to make sure that your app can ... > service) and install MDAC 2.8 again. ... > terminal service with another user account and check if MDAC 2.8 is ... > installed correctly with Component Checker. ...
    (microsoft.public.data.ado)
  • Re: Any help here???
    ... If you are having odd connectivity issues then ... AFAIK you cannot uninstall MDAC once its installed. ... Format your drive, do a new/clean install of XP, and go from there. ... > troubleshoot SQL Server connectivity issues - you should investigate the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Could not install or remove the Internet Authentication
    ... I want to roll back the MDAC install. ... IAS does not start because it is not installed. ... It sort of behaves like incorrectly configured connection to an Oracle ...
    (microsoft.public.internet.radius)