This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / SQL Server的大侠请进我这里一台Windows NT 4.0+SP6上装了SQL Server 7.0，数据库运行正常，但当我在Enterprise Manager里打开一个表（Return all rows），我得到一个error message：Provider cannot be found, it may not be installed properly。我试着装了SQL Server 7.0的Service Pack 4，但还是不行。有没有碰到同样问题的？多谢！
-bluej(小J);
2002-7-16
{292}
(#639797@0)
-
^
-bluej(小J);
2002-7-16
(#639825@0)
-
大侠不敢当,随便说两句.出现这个问题的主要原因可能是:
1. the sql tool on the client side is corrupt and u need to reinstall the tool.
or
2. the MDAC component on the client may be not compatible with the service pack level on the server and you have to apply the same version of MDAC on both the client and the server.
除非table 很小,否则尽量不要用EM 去直接打开table 并返回所有records. 尽量用query analyzer 或者osql/isql.
-yangn(Raymond);
2002-7-16
{405}
(#639976@0)