需要帮助-SQL Server 2000 [英] Need Help - SQL Server 2000

问题描述

我们有在Windows 2003/SQL Server 2000/SQLXMLOLEDB.3.0上运行的经典ASP脚本...

最近，我们更改了主机.现在，当我们尝试执行脚本时，将收到以下错误消息.

我们的连接字符串是
str =提供程序= SQLXMLOLEDB.3.0;数据提供程序= SQLOLEDB;初始目录= XXX;数据源= XXXX;用户ID = sa;密码= sa;"


ADODB.连接错误''800a0e7a''

找不到提供者.它可能未正确安装.


请帮我...

在此先感谢您！!!!!

We have Classic ASP script which run on windows 2003 / SQL Server 2000 / SQLXMLOLEDB.3.0 ...

Recently we changed host. Now when we try to execute our script we get following error message .

Our connection string is
str = "Provider=SQLXMLOLEDB.3.0;Data Provider=SQLOLEDB;Initial Catalog=XXX;data source=XXXX;User ID=sa;Password=sa;"


ADODB.Connection error ''800a0e7a''

Provider cannot be found. It may not be properly installed.


Pl help me...

Thanks in advance!!!!

推荐答案

听起来像是提供程序的声音未安装在您移至的主机上


http://www.connectionstrings.com/Providers/sqlxml-3-0-oledb-provider [^ ]

您必须使用该提供程序吗?也许尝试其他连接字符串，例如

http://www.connectionstrings.com/sql-server#p6 [

Sounds like the provider isn''t installed on the host you have moved to


http://www.connectionstrings.com/Providers/sqlxml-3-0-oledb-provider[^]

Do you have to use that provider? Maybe try a different connection string, e.g

http://www.connectionstrings.com/sql-server#p6[^]

这篇关于需要帮助-SQL Server 2000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！