EM ADD COLUMN ODBC ERROR - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

EM ADD COLUMN ODBC ERROR

Author

Topic

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-11-04 : 14:04:28

Has anyone applied the hotfix for kb81085 - Memory Stress.

After we received the patch from microsoft we have some developers who are not able to alter tables from em giving odbc errors.
Everything works fine through QA.

Anyone ever ran into this issue.

I'm not even sure the two are related.

Any info would be appreciated.

X002548
Not Just a Number

15586 Posts

Posted - 2003-11-04 : 16:10:56

I have a question...

How come they're developing (Altering) in EM?

Always seemed quirky.

Brett

8-)

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-11-04 : 18:01:08

X002548:
Because best practices need to be developed.

Anyways I was able to find the two microsoft hotfixes for the problem.
I'm up to ver. 871.

What's everyone else on?

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-11-04 : 18:03:58

I'm having problems with the hotfix for win2003 ent svr.
Everything was closed at install time.
Machine was reebooted once when hotfix failed and
hotfix retry was attempted, which still failed.
See the log below.

Anyone have a solution?

Thanks.

=====================================================
Setup is about to check write/exclusive lock on files
=====================================================
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Data\distmdl.ldf
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Data\distmdl.mdf
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Install\instdist.sql
Sensing file lock on C:\Program Files\Microsoft SQL Server\80\COM\msgprox.dll
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Install\replmerg.sql
Sensing file lock on C:\Program Files\Microsoft SQL Server\80\COM\replprov.dll
Sensing file lock on C:\Program Files\Microsoft SQL Server\80\COM\replrec.dll
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Install\replsys.sql
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmap70.dll
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlrepss.dll
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Exe\sqlservr.pdb
Sensing file lock on C:\Program Files\Microsoft SQL Server\80\COM\sqlvdi.dll
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ssnetlib.dll
Sensing file lock on C:\WINDOWS\system32\dbmslpcn.dll
File C:\WINDOWS\system32\dbmslpcn.dll is WRITE LOCKED
Sensing file lock on C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ssmslpcn.dll

===============================================================================
One or more of the selected files for replacement are locked by other processes
===============================================================================

Error message: One or more of the files selected for patching is locked by other processes. The log file has detailed information about the locked files.

Please close all applications and restart the Hotfix Installer. If the problem persists, you may have to restart your computer and then restart the Hotfix Installer.
<EndFunc Name='DoHotFix' Return='32' GetLastError='0'>
INSTALL FAILURE: Hotfix failed to apply the patches on instance MSSQLSERVER, the error code returned was: 32

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources