Re-install MDAC 2.6

I currently have SQL 2000 SP2 and MDAC 2.6 SP2 on our
database server. I am testing the process to go to
SP3a and MDAC 2.71a.
Once at SP3a and MDAC 2.71a, I tested reverting back to
SQL SP2 and MDAC 2.6 SP2 by uninstalling SQL 2000,
reinstalling SQL 2000 and SP2. However MDAC did not
revert back to 2.6 SP2. It stayed at 2.71a.
What is the proper procedure to get back to MDAC 2.6 SP2?
"Mark Gozick" <mgozick@.diamondtriumph.com> wrote in message
news:0b9401c4ac78$39e7c4c0$a301280a@.phx.gbl...
> I currently have SQL 2000 SP2 and MDAC 2.6 SP2 on our
> database server. I am testing the process to go to
> SP3a and MDAC 2.71a.
> Once at SP3a and MDAC 2.71a, I tested reverting back to
> SQL SP2 and MDAC 2.6 SP2 by uninstalling SQL 2000,
> reinstalling SQL 2000 and SP2. However MDAC did not
> revert back to 2.6 SP2. It stayed at 2.71a.
> What is the proper procedure to get back to MDAC 2.6 SP2?
>
You might need to rebuild your server -- as I recall, there is no clean way
to remove, or down-level MDAC.
Steve

Re-install MDAC 2.6

I currently have SQL 2000 SP2 and MDAC 2.6 SP2 on our
database server. I am testing the process to go to
SP3a and MDAC 2.71a.
Once at SP3a and MDAC 2.71a, I tested reverting back to
SQL SP2 and MDAC 2.6 SP2 by uninstalling SQL 2000,
reinstalling SQL 2000 and SP2. However MDAC did not
revert back to 2.6 SP2. It stayed at 2.71a.
What is the proper procedure to get back to MDAC 2.6 SP2?"Mark Gozick" <mgozick@.diamondtriumph.com> wrote in message
news:0b9401c4ac78$39e7c4c0$a301280a@.phx.gbl...
> I currently have SQL 2000 SP2 and MDAC 2.6 SP2 on our
> database server. I am testing the process to go to
> SP3a and MDAC 2.71a.
> Once at SP3a and MDAC 2.71a, I tested reverting back to
> SQL SP2 and MDAC 2.6 SP2 by uninstalling SQL 2000,
> reinstalling SQL 2000 and SP2. However MDAC did not
> revert back to 2.6 SP2. It stayed at 2.71a.
> What is the proper procedure to get back to MDAC 2.6 SP2?
>
You might need to rebuild your server -- as I recall, there is no clean way
to remove, or down-level MDAC.
Steve

Reinstall

Don't know if this will help, but I always make it a
practice to install the most recent MDAC before doing any
SQL Server maintenance. When you don't have the latest
MDAC, the SQL install errors you could get are really off
the wall. Also I believe the current MDAC (version 2.8, I
think) has a security patch you should install.

>--Original Message--
>I'm trying to reinstall SQL Server without much sucess.
I did an uninstall and deleted all old databases, then did
all updates for Windows 2000 Server, tried to install SQL
Server Standard, but I'm getting a configuration failed
error. When I check the sqlstp.log the line "[Microsoft]
[ODBC SQL Server Driver][Named Pipes]Connection broken."
appears several times after cnfgsvr.exe starts. Ultimatly
it fails and sends a (-1) exit code. Do I have a conflict
with 1 or more Hotfixes? I'm not a SQL expert, so any
help would be appreciated.
>-Rick
>.
>
Scott,
Thanks for your help! That did the trick. I guess one the the updates had back leveled MDAC. Odd that it didn't work anyway...oh well. Thanks again.
-Rick
"Scott" wrote:

> Don't know if this will help, but I always make it a
> practice to install the most recent MDAC before doing any
> SQL Server maintenance. When you don't have the latest
> MDAC, the SQL install errors you could get are really off
> the wall. Also I believe the current MDAC (version 2.8, I
> think) has a security patch you should install.
>
> I did an uninstall and deleted all old databases, then did
> all updates for Windows 2000 Server, tried to install SQL
> Server Standard, but I'm getting a configuration failed
> error. When I check the sqlstp.log the line "[Microsoft]
> [ODBC SQL Server Driver][Named Pipes]Connection broken."
> appears several times after cnfgsvr.exe starts. Ultimatly
> it fails and sends a (-1) exit code. Do I have a conflict
> with 1 or more Hotfixes? I'm not a SQL expert, so any
> help would be appreciated.
>

Reinstall

Don't know if this will help, but I always make it a
practice to install the most recent MDAC before doing any
SQL Server maintenance. When you don't have the latest
MDAC, the SQL install errors you could get are really off
the wall. Also I believe the current MDAC (version 2.8, I
think) has a security patch you should install.

>--Original Message--
>I'm trying to reinstall SQL Server without much sucess.
I did an uninstall and deleted all old databases, then did
all updates for Windows 2000 Server, tried to install SQL
Server Standard, but I'm getting a configuration failed
error. When I check the sqlstp.log the line "[Microsoft]
[ODBC SQL Server Driver][Named Pipes]Connection broken."
appears several times after cnfgsvr.exe starts. Ultimatly
it fails and sends a (-1) exit code. Do I have a conflict
with 1 or more Hotfixes? I'm not a SQL expert, so any
help would be appreciated.
>-Rick
>.
>Scott,
Thanks for your help! That did the trick. I guess one the the updates had
back leveled MDAC. Odd that it didn't work anyway...oh well. Thanks again.
-Rick
"Scott" wrote:

> Don't know if this will help, but I always make it a
> practice to install the most recent MDAC before doing any
> SQL Server maintenance. When you don't have the latest
> MDAC, the SQL install errors you could get are really off
> the wall. Also I believe the current MDAC (version 2.8, I
> think) has a security patch you should install.
>
> I did an uninstall and deleted all old databases, then did
> all updates for Windows 2000 Server, tried to install SQL
> Server Standard, but I'm getting a configuration failed
> error. When I check the sqlstp.log the line "[Microsoft]
> [ODBC SQL Server Driver][Named Pipes]Connection broken."
> appears several times after cnfgsvr.exe starts. Ultimatly
> it fails and sends a (-1) exit code. Do I have a conflict
> with 1 or more Hotfixes? I'm not a SQL expert, so any
> help would be appreciated.
>