erwin连接sql 2005问题

 (转载:huangy82的博客)

数据库建模工具用的最多是pd了吧，pd确实很强大，设计出来的东西也很美观，微软的viso太不好用了，但是sysbase的pd必须得断开网络才能使用，不然sysbase公司的律师会给你打电话，说不来还要告你，所以让人很不爽，最近在用erwin，erwin 7.1功能强大啊，今天遇到了这样的问题，erwin7.1连接不上sql 2005，在网上搜索了好多资料没有消息，包括外国网站。报什么连接不上客户端的问题，看到了一些牛人的解释，感觉还不对，因为好多人测试了以后，还是不行。最后发现时少了个 sql server 2000的组建
NTWDBLIB.DLL，版本为sql 2000（8.0），直接copy到C:\WINDOWS\system32下就行，很高兴的就解决了，与大家共同学习，参考一下文章：
If you are trying to connect to SQL Server 2005 from a machine that does not have the SQL Server 2000 client installed, you will not be able to connect to SQL Server 2005 using AllFusion ERwin Data Modeler or AllFusion Model Manager. AllFusion ERwin Data Modeler and AllFusion Model Manager require the use of DB-Library for connecting to SQL Server databases. SQL Server 2005 no longer distributes the DB-Library files, though DB-Library is supported for connecting to SQL Server 2005.

In order to be able to connect to SQL Server 2005, the file NTWDBLIB.DLL needs to be installed on your workstation. If you have a SQL Server 2000 installation CD, the SQL Server 2000 client can be installed from the CD by executing sqlredis.exe located on in the \x86\Other folder. If you do not have a SQL Server 2000 installation CD, you will need to contact Microsoft support.