怎样解决SQL Server:“Could not create component categories manager”和“Could not create an instance of the DTS package”错误

王朝mssql·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

因为做测试在一台Windows Server 2003的机器上安装了一套BizTalk 2004(也可能不是由于装了这个导致的),突然发觉没有办法在Enterprise Manager里面导入、导出数据。查了一下微软支持网站没有任何想法,于是老办法google了一下,居然发现这样一篇小文章,跟各位分享:

This can happen after some additional software has been installed, and DLLs required by DTS have been overwritten. The main culprit is Comcat.dll (winnt\system32). Version 4.71 is required for DTS to function correctly. For a quick fix copy Comcat.dll from your SQL 7 CD-ROM, and register it as described below. If this does not work then start working your way through the suggestions below.

(Re-)Apply SP1 or SP2

(Re-)Install Internet Explorer 5

Copy Comcat.dll from the SQL 7 CD-ROM to \winnt\system32, replacing the existing version.

Re-register comcat.dll [Regsvr32 \winnt\system32\comcat.dll]

Re-register the DTS DLLs

Regsvr32 \mssql7\binn\axscphst.dll (SQL Server 2000: \Microsoft SQL Server\80\Tools\Binn\axscphst.dll)

Regsvr32 \mssql7\binn\dtsffile.dll (SQL Server 2000: \Microsoft SQL Server\80\Tools\Binn\dtsffile.dll)

Regsvr32 \mssql7\binn\dtspkg.dll (SQL Server 2000: \Microsoft SQL Server\80\Tools\Binn\dtspkg.dll)

Regsvr32 \mssql7\binn\dtspump.dll (SQL Server 2000: \Microsoft SQL Server\80\Tools\Binn\dtspump.dll)

Regsvr32 \mssql7\binn\dtsui.dll (SQL Server 2000: \Microsoft SQL Server\80\Tools\Binn\dtsui.dll)

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航