SQL 7 Install Hangs On MDAC.
Oct 3, 2001While installing SQL 7.0 on nt4/sp6 it hangs during the MDAC portion.
The copying of files is succesfull but when it goes to the MDAC portion it hangs.
While installing SQL 7.0 on nt4/sp6 it hangs during the MDAC portion.
The copying of files is succesfull but when it goes to the MDAC portion it hangs.
Hi all,
About to start a project to upgrade to MDAC 2.8 from MDAC 2.6 on a number of servers. Has anyone encountered any issues with this? Also, if we do NOT upgrade several client workstations, might we expect problems as a result?
We are aware that we need to patch MDAC for the vulnerability issues, but we are trying to comine this with a server upgrade for servers at risk. Has anyone had experience on a similar project?
Cheers,
Dun
I have been trying all day to install SQL 7.0 on an NT 4.0 SP6a server. It gets to the point where it wants to load MDAC and just goes out to lunch. No errors are generated and the rest of the system does not appear to be affected. However, the only way to end the install is to end task it. Has anyone run into this?
View 1 Replies View RelatedFirst off, let me say it took me nearly all day to get this working. When you download the sql2decksp3.exe you might think it install like any other program. No. This exe simply unpacks the setup files. The actual setup program, setup.exe must be run from a DOS command prompt.... so you've got to look up the correct command line parameters in the sp3reademe.htm file. Something like:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"
No problem so far, but then when I go to run the setup.exe with the correct parameters the install goes fine until the last 5 seconds. Then hangs. Again and again. The install program keep getting hung up just before the finish. Each time I had to uninstall and reinstall-- 6 times. When if it hangs you've got to break out with the Task Manager, then do an uninstall from the Control Panel... if... an entry there was created. It usually is.
I tried everything I could think of and then did a search here. There were a few messages. The only one who actually got past this problem said he deleted all references for "Microsoft SQL" in the registry. I tried that too. It didn't work for me. That setup hung in the very same place. Then instead of breaking out and starting again, I tried shutting the machine down, while the setup was hung, thinking that maybe after a restart the installation might continue AND and that point the install completed.
Hope these notes help the next person who runs into the same problem. I also tried putting the modem on standby and disabling Norton anti-virus. Alone that did help, but when I tried all this stuff together... finally at 4:34 PM, I was able to establish a connection, from both VB.NET and with a great FREE MS SQL Manager at http://sqlmanager.net/products/mssql/manager/download
Now I can start. For some reason, the way I think... I can't do any coding until the entire database spec is first set up. Then you write all the add, edit, display and sort form, windows. When designing web applications, you design the database first, then each web form preforms some unique operation or reference on the remote database. I think that's the way it works.
Hey! Hope this helps others.
Paul Townsend
I installed MSDE. Then I changed the name of my machine. Then I uninstalled MSDE, so I could create a new, properly-named instance.
Now, when I try to install, the installer gets about 75% of the way through the "gathering information" stage, and hangs, every time. I have to kill it with Task Manager.
Help! What can I do?
Extra info: I thought maybe the problem was related to Norton AV, so I uninstalled that. While that was uninstalling, the installer announced that there was a "suspended" install of MSDE that needed to be cleared. So I said, yes, clear it. How do I find out if there are other suspended installs in progress?
Thanks...
Hi,
I hope someone out there can help, cos i really need it.
We have a 2 node cluster + SAN that will be used as our SQL 2000 servers.
We have setup the cluster ok, and have tested failover with no problems.
However, when we try to install SQL 2000, it just hangs.
I have copied the enterprise cd to the local drive, and am installing from there.
We run the setup.bat, create the Virtual Server, and assign an ip address. At this point, it just hangs.
Upon checking the SQLSTP.LOG file, this is the last entry in the log:
Begin Action : DialogShowSdDiskGroups
I have found the Microsoft Technet Article 293788, which gives me a possible soloution, but we dont have any Resource Names or Groups that have the same name.
Can someone PLEASE give me an answer on how to fix this, or at least point me in the right direction.
Many Thanks
Darren
Just purchased a new server, and am trying to install SQL Server 2005 standard, 64 bit. I'm running Windows Server 2005 r2 64 bit.
Setup support files installs fine.
System configuration passes all 14 checks.
Then it moves to install and just hangs there. Eventually, perhaps maybe after 20-30 minutes does it create a message saying that the Install has failed to respond. Retry or cancel.
I am experiencing extremely slow behavior (no activity for > 30 mins) during a SS 2005 Dev Edition install on XP SP2 on various steps during the SQL Server Database Services step - e.g. during "Setting File Security". This is very annoying.
I've found many postings on this issue indicating that OS calls in this part of the install (e.g. LookupAccountName()) are network speed dependent.
Does Microsoft have any plans to rework this part of the install to rid the need of these calls? I really wish the install would be possible without these calls - it's driving me crazy monitoring this for hours. We've got to roll SS2005 out to a couple hundred developers eventually and this isn't going to cut it.
Thanks for your time on this matter.
Best Regards,
Mike
I am trying to install SQL Server 2012 onto an already configured and validated windows failover cluster (server 2012) but the process is hanging after installing the setup files.
The last entry in the log is:
running discovery on remote machine
and I've left it hanging like this for 4 hours and nothing happens.
HELP!
For the past several weeks, I have been trying to install SQL Server 2005 on a Win XP SP2 PC. Regardless of the options I choose (SQL Engine + Client Tools, Client Tools only, etc.) when the installation gets to the end of the Client Tools setup and the setup status displays "Removing Backup Files", my PC appears to hang.
For a period of time, there is a fair amount of HD activity which gives me the impression that files are in fact being deleted, but then there is no HD activity and the installation appears to hang. Finally I give up and kill the setup process and reboot.
After reboot, it appears that the client tools have been installed (the icons appear and I can open the Management Studio, but when I try to connect to an existing instance of SQL, that hangs. This occurs for either Windows or SQL authentication.
Has anyone experienced this behavior and determined the root cause? What EXACTLY is happening during the "Removing Backup Files" phase of the installation?
Thanks for any help in advance,
Marc Mueller
We are in the process to upgrading from SQL 7.0 SP1 on a NT 4 EE sp6a active/passive cluster to a SQL 2K SP2 on the same NT 4 EE sp6a active/passive (single instance I think it is called now) cluster.
My question now is about MDAC.
Do I need to upgrade all my clients (W98 SE) that actually have MDAC 2.5 installed to the 2.6 version of the product?
Is there any MS articles that clearly explain this argument?
Thank you in advance.
Best Regards.
Franco
Ive got a question on MDAC and SQL 2000.
We have a SQL Server 7.0 running on NT 4.0 with MDAC 2.1 installed.
We also have a SQL Server 2000 running on Windows 2000 with MDAC 2.6 installed, as well as other instances of 7.0 and 2000.
I am trying to setup Push replication from the box with SQL 7.0 and MDAC 2.1 installed to a 2000 server with MDAC 2.6.
A SQL 7 to 2000 push works if an instance of 7 and 2000 are installed on the same machine. I can push to any remote machine, except for the one server with MDAC 2.1 installed.
Could MDAC be my problem?
Thanks,
Kyle
We have a large project that is importing msado21.tlb. We want to import least msado25.tlb to access the ADODB::_Stream object, but are unsure what exactly this entails. I've noticed no problems testing that change, but I cannot find any changelog for the MDAC upgrade. Is anyone aware of, or can point me to, a list of changes (fixes, modifications, caveats, etc) between MDAC 2.1 and MDAC 2.5? The binary msado file is always much newer, of course, but we want to link with the older type libraries to maintain maximum compatibility.
Any help is appreciated, I'm at a dead end!
How to find out what version of MDAC is running on the server?
View 1 Replies View RelatedHello guys,
What is the use of MDAC and how to check the version of MDAC.
on any server.
Thank you.
Paul
Hi folks. Got a real doozy going. One of the network techs reinstalled NT4 SP5 on a server. This reverted the SQL driver back to 2.something. Now sqlserveragent jobs will not run.
I have tried to instal MDAC 2.5, but it doesn't change the driver up to the new 3.xxx driver. I searched around on here and folks said that you have to move the MDAC executable to a new directory. for the new MDAC I don't see MDAC.EXE. I did find MDAC.COM and renamed that. Tried to rerun MDAC 2.5 but still got the old SQLSRV32.Dll.
Uninstalled SQLServer and reinstalled. still got the old SQLSRV32.Dll.
Tried to apply SQLServer SP1. It died.
Found that I am to shutdown some services. Did that. SP1 still dies.
Tried to apply SQLSERVER SP2. It tries to pick up where it died and it dies again.
SO, I'm currently uninstalling SQLServer, reboot, installing SQLServer, reboot, Trying SP2 again.
Didn't think that it was brain surgery just to install a new flippin version of the ODBC driver.. SHEEZ!!!!
I'm in a mild-debate with some colleagues of mine.
Can someone shed some light on this for me.
(This is related to a problem we are having with empty recordsets being returned where we know there should be rows returned. I think it could be caused by incorrect/outdated MDAC components.)
We use SQL 7 sp2, and ado DSN'less connection strings.
MSSQL .7.0 SP2
WIN2KPRO
ATI 32mb video
1.3gh AMD
1g Ram
No other apps are affected....my once fast system is slowed to a crawl. 5+gb
free on C 37gb on E and NO apps loaded in systray. NO background processes,
nunca.
I installed MDAC 2.6 on a system to try to correct an OLE error when using
sp_OACreate that causes an ODBC connection broken and shuts down SQL every
other execution.
***** Now, the system is running slow, I tried reinstalling, moving the data
to a single local drive. (No other apps appear to be slowed)
Uninstalled MDAC 2.6 and reverted to 2.5 still slow.
Reinstalling MSSQL 7 and SP2, and MDAC 2.5 still slow...
As an example, when a simple xp_cmdShell 'dir c:mssql7data*data.mdf' the
resulting 10 lines are slowing typed accross the screen. On most systems
the text is refreshed so fast we only see a flicker.
Cleaning the registry still slow... Profiler shows DML and GHost lines that
appear to suck the life out my system, but its only pegged at 2%, like it's
doing something, but what(?)
Tonight I may have to reformat and reload, however I've seen this before and
would really like a clue.
JeffP...
We use mdac 2.7 on all servers and clients
We want to update servers to 2.8
Do we MUST update clints to 2.8 or they
can continue to run with 2.7
Thank you
Alex
Can anyone please help?
How do I find out which MDAC version my pc is running on and how do I update to the latest version??
Thanks in advance!!!
Hi everbody,
How can i found out which version of MDAC version running of my production box.
Regards
Fluvio
What version of MDAC comes with SQL 2000?
View 2 Replies View RelatedHi,
I install MDAC 2.8 the installation is ok, i reboot and when i look in add/remove programs box there isn't mdac.
And my entreprise manager tools don't work properly.
It's very urgent please help me.
i need to uninstall MDAC from my system. my operating system is windows2000 proffessional.
pls help me.... its very urgent.....
Hi All
may be my post sounds stupid but i have on idea about it.
can some one there please clear what is relationship between MDAC and SQL Server. id MDAC part of SQL Server or it is optional tool for some thing else. what it is excatly and links to useful tutorial etc.
How to check MDAC version.
What are the version supported for sql 7.0 cluster witn w2k sp1.
TIA
Paul
I installed MDAC 2.6 SP1 on my 2000 machine in order to get SQL server 7.0 to work properly on my machine. I'm trying to get installed on server which is on NT 4.0 SP6 so that when I save a DTS package on my 2000 machine and run it on the server it doesn't get the error client access ODBC driver not capable. I intalled MDAC 2.6 SP1 on the server but it doesn't look like its updating it. The install goes fine. I reboot but when I go into the ODBC connections and look at the driver for the client acceess it still has version 6.00.00.05 while my 2000 machine says 6.00.07.00
Any ideas on why its not updating. Can I just take the DWBODBC.DLL from my machine and copy it to the server?
Hi,
I have a SQL 7 Server running SP2/MDAC 2.5. One of my techs accidentally loaded mdac 2.6 on a machine and it no longer could establish ODBC connections to my SQL server. I used the CC check utility to roll it back, but was wondering why the 2.6 client could no longer attach to my server. In the past I have had 2.1 on my server with 2.5 clients that connected with very few problems. At least not a major one like a failing ODBC connection. Do I need to upgrade my server to 2.6 before my clients?
i was wondering if there is anyway to downgrade the MDAC to 2.5 (or specicifically the sqlsrv32.dll to 3.70.06.23) on an XP machine?
WHY? - http://www.dbforums.com/t1043791.html
it seems that starting with MDAC 2.8 the FETCH NEXT statement for cursors requires an INTO clause. otherwise an unspecified error is returned.
so it's not possible to scroll through the records anymore without storing the values of the fields into local variables?
I am trying to load a project under VS2005 under Windows Vista that references an ADOX wrapper that is looking for version 2.8.0.0. The reference fails because the library is not registered.
I thought maybe installing MDAC 2.8 would solve my problems, but when I run the installer for that, it briefly puts up a dialog that it is extracting files, then it disappears.
Any ideas?
--Bruce
What kind of components does MDAC 2.8 SP1 give you for Visual Studio 2005? Thanks!
View 1 Replies View RelatedHi, I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousends). It is using the SQL ADO provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790).
Is there a knwon bug like this? Is there a way to trace the ADO provider?