odbc_exec 错误与进度
我正在使用 Codeigniter 数据库活动记录(ODBC 驱动程序)。该应用程序运行良好。但从今天开始,尝试从 Progress 数据库(通过 odbc 连接)获取数据时出现错误。错误信息:
严重性:警告 --> odbc_exec() [function.odbc-exec]: SQL 错误: [DataDirect][ODBC Progress OpenEdge 有线协议驱动程序]意外 网络错误。 ErrNum = 10054,SQLExecDirect 中的 SQL 状态 08S01 D:\xampp\htdocs\wavinet2-permana\system\database\drivers\odbc\odbc_driver.php 153
odbc_exec 命令出错。当我尝试在不使用 Codeigniter Active Record 的情况下获取数据时,它可以工作。已获取数据。尝试 var_dump($this->db_odbc->conn_id) 它返回资源。网络错误?我尝试在 SQLServer 上设置 LinkedServer 并运行 ActiveRecord 生成的查询,它工作正常,数据已成功获取。
我很困惑,导致错误的另一种可能性是什么?
I am using Codeigniter Database Active Record (ODBC Driver). The application run well. But starting this day, there are error when trying to fetch data from Progress database (connected via odbc). The error message:
Severity: Warning --> odbc_exec() [function.odbc-exec]: SQL error:
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected
Network Error. ErrNum = 10054, SQL state 08S01 in SQLExecDirect
D:\xampp\htdocs\wavinet2-permana\system\database\drivers\odbc\odbc_driver.php
153
Error is in odbc_exec command. When I try to fetch data without using Codeigniter Active Record, it work. Data fetched. Trying to var_dump($this->db_odbc->conn_id) it return Resource. Network error ? I try to set up LinkedServer on my SQLServer and run the query generated by ActiveRecord, it work, data fetched successfully.
I'm confuse, what is another posibilities that cause the error ?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
首先确保您已正确启动数据库。有一个相当重要的线程,听起来可能是您的问题: http://www.progresstalk.com/showthread.php?116855-102B-ODBC-connection-Problem
如果您通过 SSL 运行,还需要注意其他事项:
请参阅:http://knowledgebase.progress.com/articles/Article/8500
First make certain that you have started up your database properly. There is a fairly substantial thread that has what sounds like it may be your problem here: http://www.progresstalk.com/showthread.php?116855-102B-ODBC-connection-Problem
Also something else to look at if you are running over SSL:
See: http://knowledgebase.progress.com/articles/Article/8500