#48122 [Opn->Fbk]: odbc_cursor() returns empty name
| From: | jani@php.net | Date: | Wed, 06 May 2009 21:37:31 +0000 |
| Subject: | #48122 [Opn->Fbk]: odbc_cursor() returns empty name | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-136892@lists.php.net to get a copy of this message | ||
ID: 48122
Updated by: jani@php.net
Reported By: theodoreb at goshen dot edu
-Status: Open
+Status: Feedback
Bug Type: ODBC related
Operating System: Gentoo Linux
PHP Version: 5.2.9
New Comment:
Try this:
<?php
error_reporting(E_ALL);
$conn = odbc_connect("mssql", "login", "passwd",SQL_CUR_USE_ODBC);
var_dump($conn, odbc_errormsg($conn));
$query = "SELECT * FROM tablename";
$cur = odbc_exec($conn,$query);
var_dump(odbc_errormsg($conn));
echo odbc_cursor($cur);
var_dump(odbc_errormsg($conn));
?>
Previous Comments:
------------------------------------------------------------------------
[2009-04-30 16:08:45] theodoreb at goshen dot edu
Description:
------------
odbc_cursor() returns empty string when the connection is created using
odbc_connect() with SQL_CUR_USE_ODBC as the fourth parameter.
Using unixODBC-2.2.12 and freetds-0.82-r2 to connect to Microsoft SQL
Server 2008.
Reproduce code:
---------------
$conn = odbc_connect("mssql", "login", "passwd",SQL_CUR_USE_ODBC);
$query = "SELECT *
FROM tablename";
$cur = odbc_exec($conn,$query);
echo odbc_cursor($cur);
Expected result:
----------------
cursor name of $cur, something like SQL_CURa70b90
Actual result:
--------------
empty string ''
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=48122&edit=1