为什么 OpenEdge ODBC 连接在 IIS 中失败并出现错误 126,但在 VS2010 中却出现错误?
我有一个 ASP.net Web 服务应用程序,它通过 ODBC 连接到 Progress OpenEdge 10.1B 数据库。我的开发机器是 XP Pro,运行一切正常。我现在正在将应用程序转移到测试环境中。测试机也是XP Pro。它与开发机器匹配,只是 Progress Server 不在本地运行。我能够在 VS2010 中运行该项目,并且 Web 服务建立 ODBC 连接并返回数据,没有错误。当我将应用程序部署到 IIS(在本地运行)时,ODBC 连接失败并出现以下错误:
*System.Data.Odbc.OdbcException: ERROR [IM003] 由于系统错误 126 (OpenEdge),无法加载指定的驱动程序10.1B 驱动程序)。 *
这是怎么回事?
I have an ASP.net web service application that connects to a Progress OpenEdge 10.1B database via ODBC. My development machine is XP Pro and runs everything fine. I am now moving the application into a test environment. The test machine is also XP Pro. It matches the dev machine except for that the Progress Server is not running locally. I am able to run the project out of VS2010 and the web service makes the ODBC connection and returns the data without error. When I deploy the application to IIS (which is running locally) the ODBC connection fails with this error:
*System.Data.Odbc.OdbcException: ERROR [IM003] Specified driver could not be loaded due to system error 126 (OpenEdge 10.1B driver).
*
What is going on here?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
请尝试位于 http://progress.atgnow.com/esprogress/Group 的进度知识库。 jsp?bgroup=progress
此条目似乎可能相关:
ID:P36468
标题:“由于加载 ODBC 驱动程序时出现错误 126,ASP 页面无法启动”
创建时间:2003 年 8 月 11 日 最后修改时间:2008 年 10 月 14 日
状态:已验证
症状:
由于加载 ODBC 驱动程序时出现错误 126,ASP 页面无法启动
由于系统“错误 126”,无法加载指定的驱动程序(MERANT 3.70 32-BIT PROGRESS)
从 ODBC 数据管理测试连接工作正常
使用IIS内置的IIS和ASP帐户。
事实:
Windows NT 32 位英特尔/Windows 2000
进度 9.1 倍
IIS
原因:
IIS内置帐户(IUSR_machine_name)没有访问网络的权限
如果 Progress 已安装在网络共享驱动器上,则会出现这种情况。
修复:
将本地驱动器上的Progress安装到IIS并添加读取和执行
IUSR帐户对安装目录中所有文件的权限。
Try the Progress Knowledgebase at http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress
This entry seems potentially relevant:
ID: P36468
Title: "ASP page fails to launch due to the error 126 when loading the ODBC driver"
Created: 08/11/2003 Last Modified: 10/14/2008
Status: Verified
Symptoms:
ASP page fails to launch due to the error 126 when loading the ODBC driver
Specified driver could not be loaded due to system "error 126" (MERANT 3.70 32-BIT PROGRESS)
Testing the connection from ODBC Data Administration works fine
Using IIS built in account for the IIS and ASP.
Facts:
Windows NT 32 Intel/Windows 2000
Progress 9.1x
IIS
Cause:
IIS built-in account (IUSR_machine_name) does not have permissions to access network
resources which will be the case if Progress has been installed on the network shared drive.
Fixes:
Install Progress on the local drive to the IIS and add the read and execute
permission for the IUSR account to all the files in the installation directory.