Removing MDAC

Hi!!!!
I need to remove the MDAC in order to remove ODBC drivers.
How can I do this?
I have Windows XP SP1 which comes with MDAC 2.7 but the third party
application installs an older version of MDAC (it seems to be MDAC 2.1) and
now another third party applicattion claims to install a MDAC 2.5 but this
application not update the MDAC. The installation process needs MDAC 2.1 be
removed.
How can I do this?
Thanks for any informationYou can change MDAC versions but you can't totally remove
MDAC on XP. I'm not sure what all you have done with your
current installation but try reinstalling the latest MDAC.
You can also use the component checker to check your MDAC
installation and version. You can download the recent MDAC
versions from:
http://msdn.microsoft.com/data/down...es/default.aspx
You can download the component checker from:
http://msdn.microsoft.com/data/down...ls/default.aspx
-Sue
On Fri, 27 Feb 2004 15:24:31 -0300, "The Desperate Newbie"
<desperate.newbie@.hotmail.com> wrote:

>Hi!!!!
>I need to remove the MDAC in order to remove ODBC drivers.
>How can I do this?
>I have Windows XP SP1 which comes with MDAC 2.7 but the third party
>application installs an older version of MDAC (it seems to be MDAC 2.1) and
>now another third party applicattion claims to install a MDAC 2.5 but this
>application not update the MDAC. The installation process needs MDAC 2.1 be
>removed.
>How can I do this?
>
>Thanks for any information
>

Removing a Server Name

SQL

Upgrading to VS05 Pro SP1/SqlExpress (from VS03 Pro/SQL MSDE)

Question 1) – is there a way to tell which version of the SQL Express was installed?I think it is “SQL Server 2005 Express Edition With Advance Services”, but don’t know how to confirm that.

Question 2) - SQL Server Management Studio Express, Registered Servers, it shows :

Database Engine

\sqlexpress (note the lower case)

If I right click and choose “Previously Registered Servers”, it shows a message that I will be displaying SQL Server 2000 (i.e. MSDE) server names, and it shows

SQL Server Group

\SQLEXPRESS (note the upper case)

\CSOLUTION

I wish to completely remove\CSOLUTION (in MSDE you would uninstall it from the Control Panel), but right clicking and choosing the delete option does nothing (it does not delete it).Deleting SQL Server Group also has no affect either. How do I remove \CSOLUTION ?

Question 3) - In the VS05 program, the SQL connection string includes “Data Source=.\SQLEXPRESS….” (NOTE UPPER CASE)Why do I have a lower case and an upper case listed above?Starting/stopping one sqlexpress/ SQLEXPRESS does the same to the other.Don’t I wan’t to complete delete anything under SQL Server Group since it represents SQL Server 2000 (i.e. MSDE) server names?SQL Server 2000 and \CSOLUTION have been uninstalled from this machine.

Thanks!

bob

hi Bob,

BobInIndy wrote:

SQL

Upgrading to VS05 Pro SP1/SqlExpress (from VS03 Pro/SQL MSDE)

Question 1) – is there a way to tell which version of the SQL Express was installed? I think it is “SQL Server 2005 Express Edition With Advance Services”, but don’t know how to confirm that.

executing

SELECT SERVERPROPERTY('Edition'); --< will return Express Edition with Advanced Services --< where a "standard" SQLExpress instance returns Express Edition

Question 2) - SQL Server Management Studio Express, Registered Servers, it shows :

Database Engine

\sqlexpress (note the lower case)

If I right click and choose “Previously Registered Servers”, it shows a message that I will be displaying SQL Server 2000 (i.e. MSDE) server names, and it shows

SQL Server Group

\SQLEXPRESS (note the upper case)

\CSOLUTION

I wish to completely remove \CSOLUTION (in MSDE you would uninstall it from the Control Panel), but right clicking and choosing the delete option does nothing (it does not delete it). Deleting SQL Server Group also has no affect either. How do I remove \CSOLUTION ?

you usually uninstall an instance accessing the control panel Add/Remove applet...

as last resource you can manually delete it as described in http://support.microsoft.com/kb/290991/en-us

Question 3) - In the VS05 program, the SQL connection string includes “Data Source=.\SQLEXPRESS….” (NOTE UPPER CASE) Why do I have a lower case and an upper case listed above? Starting/stopping one sqlexpress/ SQLEXPRESS does the same to the other. Don’t I wan’t to complete delete anything under SQL Server Group since it represents SQL Server 2000 (i.e. MSDE) server names? SQL Server 2000 and \CSOLUTION have been uninstalled from this machine.

Thanks!

bob

the upper/lower case is not actually a problem...

regards