Re: Install SQL server 2000

From: Lionel (Lionel_at_discussions.microsoft.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 09:23:49 -0800

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: Sql Server Agent (2000) erroring out on DTS Packages
    ... DTSRun: Package execution complete. ... and a problem with a missing MDAC dll. ... On Sql Server 7, this was SQLAgentCmdExec. ... Specified driver could not be loaded due to system error 126 (MERANT MSSS ...
    (microsoft.public.sqlserver.dts)
  • Re: Any help here???
    ... > start looking for things that are non standard (like having MDAC installed). ... > Format your drive, do a new/clean install of XP, and go from there. ... >>> data provider is optimized for SQL Server. ... >>> I've never had any SQL Server connectivity problems since I've switch to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Help Please Wit Error
    ... Occasionally I receive the error you are mentioning when the SQL Server ... I have had to completely remove the MDAC and re-install it as well ... see an example of the connection string you are using. ... Please install Microsoft Data Access Components ...
    (microsoft.public.dotnet.csharp.general)
  • Re: different mdac, different sql server behaviour
    ... ODBC is part of MDAC and you are using the SQL Server ODBC driver. ...
    (microsoft.public.sqlserver.server)
  • 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)