ID: 40452
Comment by: daniel dot tams at gmail dot com
Reported By: aspen dot olmsted at alliance dot biz
Status: Assigned
Bug Type: PDO related
Operating System: Windows 2003, XP
PHP Version: 5.2.1
Assigned To: wez
New Comment:
I can confirm this problem on PHP 5.2.1. The exact error is the
following:
Fatal error: Uncaught exception 'PDOException' with message
'SQLSTATE[HY010]: Function sequence error: 0 [Microsoft][ODBC Driver
Manager] Function sequence error (SQLExecute[0] at
ext\pdo_odbc\odbc_stmt.c:133)' in C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\iptaa\lib\IPTAA_CRUD.class.php:135 Stack
trace: #0 C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\iptaa\lib\IPTAA_CRUD.class.php(135):
PDOStatement->execute() #1 C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\iptaa\lib\IPTAA_CRUD.class.php(414):
IPTAA_CRUD->create(Array) #2 C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\iptaa\users.php(15):
IPTAA_CRUD->handleHttpPost() #3 {main} thrown in C:\Program Files\Apache
Software Foundation\Apache2.2\htdocs\iptaa\lib\IPTAA_CRUD.class.php on
line 135
Fatal error: Exception thrown without a stack frame in Unknown on line
0
This is a pretty serious limitation of the PDO ODBC driver.
Previous Comments:
------------------------------------------------------------------------
[2007-02-13 01:31:36] aspen dot olmsted at alliance dot biz
Yes. If you insert into sql other ways it works perfect. Including
through php
------------------------------------------------------------------------
[2007-02-12 22:22:23] [EMAIL PROTECTED]
Are you sure "2007-02-12 14:5" is correct timestamp for MSSQL?
Doesn't it lack the last symbol?
------------------------------------------------------------------------
[2007-02-12 22:07:47] aspen dot olmsted at alliance dot biz
Here is the error:
Fatal error: Uncaught exception 'PDOException' with message
'SQLSTATE[HY010]: Function sequence error: 0 [Microsoft][ODBC Driver
Manager] Function sequence error (SQLExecute[0] at
ext\pdo_odbc\odbc_stmt.c:133)' in C:\Program
Files\nusphere\phped\Projects\ASCPlatform\noname1.php:11 Stack trace: #0
C:\Program Files\nusphere\phped\Projects\ASCPlatform\noname1.php(11):
PDOStatement->execute(Array) #1 {main} thrown in C:\Program
Files\nusphere\phped\Projects\ASCPlatform\noname1.php on line 11
The only thing missing from the script is:
$dbh = new PDO('odbc:peo', '11', '11');
------------------------------------------------------------------------
[2007-02-12 21:54:51] [EMAIL PROTECTED]
But you forgot the error itself.
And I would appreciate if you include a working script, too.
------------------------------------------------------------------------
[2007-02-12 21:43:30] aspen dot olmsted at alliance dot biz
I included a small script in the reproduce code?
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/40452
--
Edit this bug report at http://bugs.php.net/?id=40452&edit=1
