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: 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. Previous Comments: --------------------------------------------------------------------------- [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