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/23/04 

Date: Tue, 23 Nov 2004 10:07:57 -0700

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: 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: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)
  • 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: Using vfoledb with webservices?
    ... later MDAC package and install that. ... MDAC 2.7 or 2.8 doesn't install specific OLE or ODBC drivers for any ... particular database engines except Oracle and SQL Server. ...
    (microsoft.public.fox.programmer.exchange)