Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old July 2nd, 2002, 08:32 AM
BukHix BukHix is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2002
Location: Three Rivers, MI
Posts: 5 BukHix User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Problem installing MDAC on Windows 2000

I am having trouble getting SQL 2000 installed on a test domain controller. It crashes during the part that says it is installing the MDAC components.

I have tried installing MDAC independently and right near the end it says that Setup is rolling back the installation. There are no setup errors listed at all and the only choice is to close setup.

I have found two KB articles and went through all the suggestions and still couldn’t get it to work.

HOWTO: MDAC Setup Troubleshooting Guide (Q232060)
INFO: Component Checker: Diagnose Problems and Reconfigure MDAC Installations (Q307255)

The second KB article basically says that MDAC can not be replaced/repaired without reinstalling the operating system. Has anybody else seen this and know away around it?

I have been able to get SQL 7 installed successfully which would work fine for my purposes but I still have a problem with MDAC because when ever I try an run an ASPX page with a database connection I get this error:

The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later

Last edited by BukHix : July 2nd, 2002 at 08:44 AM.

Reply With Quote
  #2  
Old July 2nd, 2002, 01:37 PM
BukHix BukHix is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2002
Location: Three Rivers, MI
Posts: 5 BukHix User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I finaly figured this out. The solution that worked for me can be found here:

MDAC Fix

But it breaks down to this -

Q: "Installation of the Microsoft Data Access Components package failed. (-1)"-- Error occurs during setup ?

A:Some workarounds...

Sugg1
-----
Check and see if the registry key

'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Cur rentVersion\Setup\Exceptio
nComponents'

exists on the server. If it does, then you will need to
delete this key, and re run the setup. Before deleting the key, make sure
you backup the registry in case you need to restore the key. It seems
there was a previous install of MDAC that did not complete successfully or
completely

Reply With Quote
  #3  
Old July 2nd, 2002, 06:23 PM
mytch mytch is offline
Dev Articles Novice (500 - 999 posts)
 
Join Date: Apr 2002
Location: Sydney, Australia
Posts: 589 mytch User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Thanks for sharing Buk

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > Problem installing MDAC on Windows 2000


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway