PHP 4.0 Bug #6275 Updated: ODBC_Prepare/ODBC_Execute fails with parameters

ID: 6275 Updated by: kalowsky Reported By: jlim@natsoft.com.my Status: Analyzed Bug Type: ODBC related Assigned To: kalowsky Comments: further poking tonight revealed the following... in the odbc_execute function, when doing a SQLDesrcibe on the value pulled out of the array function the following message was produced by PHP/ODBC: SQL error: [Microsoft][ODBC Driver Manager\ Driver does not support this function, SQL state IM001 in SQLBindParamater <insert script name here>. Could it be that MS Access doesn't support this functionality? Is there any way to (dis)prove this theory? Previous Comments: --------------------------------------------------------------------------- [2001-03-23 17:01:42] kalowsky@php.net Tried updating to the latest MDAC (2.6) and this provided no change in the given example. It did fix one or two issues, but in generally hasn't helped any. --------------------------------------------------------------------------- [2001-03-11 20:59:58] kalowsky@php.net it seems the sample script provided is failing in the SQLBindParameter call. Why? The SQLError call tells us it's trying to bind a parameter of the wrong type. I've sent out an email on the PHP-DB list asking if anyone could try a small variation of this script, and only one person responded. It seems to be a Microsoft Access specific issue only, but my only other comparision at this time is SQL Server...draw your own conclusions. --------------------------------------------------------------------------- [2001-02-14 08:20:41] kalowsky@php.net starting to look into windows problems, only problem is I have only win98, so the winNT and 2k won't likely happen... --------------------------------------------------------------------------- [2000-08-21 09:16:20] jlim@natsoft.com.my Hello, My problem is odbc_execute fails with the following error message: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect , SQL state 07001 in SQLExecute in d:Inetpubwwwrootphpadodbindex.php on line 77 The odbc_exec INSERT works fine. I am using a plain vanilla NorthWind MS Access database and am using the ISAPI version of PHP, with ODBC built in. Sample code: $conn = odbc_connect("nwind","",""); odbc_exec($conn,"drop table ADOXYZ"); odbc_exec($conn,"create table ADOXYZ (id int, firstname char(24), lastname char(24))"); odbc_exec($conn,"insert into ADOXYZ (id,firstname,lastname) values (0,'Zend','PHP')"); $stmt = odbc_prepare($conn,"insert into ADOXYZ (id,firstname,lastname) values (?,?,?)"); if ($stmt) { print "Trying execute<br>"; $stmt = odbc_execute($stmt,array(1,"John","Lim")); } --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=6275&edit=2