MDAC Problem

From: Konstantinos Michas (anonymous_at_discussions.microsoft.com)
Date: 03/19/04


Date: Fri, 19 Mar 2004 08:11:41 -0800

Hello Experts,

I post this in this newsgroup too, hoping I got faster
response here. Thank you.

When I Open Enterprise Manager and click on my server,
following msg appears:

SQL Server Enterprise Manager
----------------------------------------------------
A Connection could not be established to (LOCAL).

Reason: Data source name not found and no default driver
specified.

Please Verify SQL Server is running....bla, bla.
----------------------------------------------------

What Cause this:

1) I have Windows XP with SP1
2) I have had installed MDAC 2.8
3) I uninstall MDAC 2.8 using "dasetup.exe /U" command,
setup found that MDAC 2.6 is referenced to MDAC 2.8 an
had to uninstall this too, I pressed OK and then the
uninstall failed because the default of Windows XP MDAC
is 2.7 SP1 and setup propably found that some other MDAC
had to be the default.

Any way, I ReInstall MDAC 2.6 (Latest), MDAC 2.7 Refresh
and Q323263_MDAC27_x86_en.

What do I have to do having as default "MDAC 2.7 SP1 on
Windows XP SP1" and ODBC Drivers work?

Is this a solution? -> Repair my registry using WinXP CD,
but I don't know how to do it :).

Thanks in advance.



Relevant Pages

  • Deployemnt of app and MDAC versions
    ... I am developing a .NET app on Win XP Sp2. ... The company standards dictate that MDAC 2.7 SP1 is installed on ... allowing me to upgrade the server to MDAC 2.8 (as other applications run on ...
    (microsoft.public.dotnet.framework.adonet)
  • Major Problem - Please Help!!!
    ... When I Open Enterprise Manager and click on my server, ... SQL Server Enterprise Manager ... I have Windows XP with SP1 ... I have had installed MDAC 2.8 ...
    (microsoft.public.sqlserver.programming)
  • Any One Respond On This? (Major Problem - Please Help!!!)
    ... When I Open Enterprise Manager and click on my server, ... SQL Server Enterprise Manager ... I have Windows XP with SP1 ... I have had installed MDAC 2.8 ...
    (microsoft.public.sqlserver.programming)
  • Major Problem - Please Respond!!!
    ... When I Open Enterprise Manager and click on my server, ... SQL Server Enterprise Manager ... I have Windows XP with SP1 ... I have had installed MDAC 2.8 ...
    (microsoft.public.sqlserver.setup)
  • Major Problem - Please Help!!!
    ... When I Open Enterprise Manager and click on my server, ... Please Verify SQL Server is running....bla, ... I have Windows XP with SP1 ... I have had installed MDAC 2.8 ...
    (microsoft.public.sqlserver.odbc)