适用于PHP的ODBC DERBY DRIVER [英] ODBC DERBY DRIVER for PHP

问题描述

我在Windows 7中安装了easysoft odbc derby驱动程序，并尝试连接到derby数据库 在ODBC数据源管理员DSN上配置并连接成功之后.

I installed easysoft odbc derby driver in windows 7 and try to connect to derby database after I configure on ODBC Data Source Administrator DSN and connection succeed.

然后我尝试了php脚本

then i tried on php script

 //commz is the DSN name ind ODBC data source admin 
$connection = odbc_connect("commz",$user, $password);

if ($result = odbc_exec($connection, "SELECT * FROM ADDRESSBOOK"))
    print "Command executed successfully<BR><BR>";
else
    print "Error while executing command<BR><BR>";

  // Print results
  while(odbc_fetch_row($result))
    print odbc_result($result, 1) . "   " . odbc_result($result, 2) . "   " . odbc_result($result, 3) . "   " . odbc_result($result, 4) . "   " . odbc_result($result, 5) . "<BR>";

  odbc_close($connection);
  print "<BR>Connection closed.";

我运行此脚本后，此味精出现

after i run this script this msg appear

已连接到数据源

警告:odbc_exec():SQL错误:[Easysoft] [ODBC-Derby 驱动程序] [DRDA]常规错误:意外命令(未返回dss)，SQL 行C:\ xampp \ htdocs \ test \ index.php中的SQLExecDirect中的状态HY000 36执行命令时出错

Warning: odbc_exec(): SQL error: [Easysoft][ODBC-Derby Driver][DRDA]General error: unexpected command (dss not returned), SQL state HY000 in SQLExecDirect in C:\xampp\htdocs\test\index.php on line 36 Error while executing command

警告:odbc_fetch_row()期望参数1为资源，布尔值 在第45行的C:\ xampp \ htdocs \ test \ index.php中给出

Warning: odbc_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\test\index.php on line 45

连接已关闭.

对此有何建议?

谢谢！

推荐答案

最好的方法是将操作的驱动程序日志发送至[e-mail]，我们将看看发生了什么.我将把我们发现的任何内容都张贴在这里.

Best thing to do, is send a driver log of the operation to [e-mail] and we will take a look at whats going on. I will post whatever we find back here.

要获取日志，请在odbc.ini文件中将其添加到您的DSN:

To get the log, add to your DSN in odbc.ini file:

Logging = Yes
LogFile = /tmp/drb.log

这篇关于适用于PHP的ODBC DERBY DRIVER的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！