php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #6275 ODBC_Prepare/ODBC_Execute fails with parameters
Submitted: 2000-08-21 09:16 UTC Modified: 2001-12-18 07:13 UTC
From: jlim at natsoft dot com dot my Assigned: kalowsky (profile)
Status: Closed Package: ODBC related
PHP Version: 4.0.1pl2 OS: Windows 98
Private report: No CVE-ID: None
 [2000-08-21 09:16 UTC] jlim at natsoft dot com dot 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:\Inetpub\wwwroot\php\adodb\index.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"));
}



Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-02-14 08:20 UTC] 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...
 [2001-03-11 20:59 UTC] 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-03-23 17:01 UTC] 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-04-01 19:36 UTC] kalowsky@php.net
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?  
 [2001-11-27 05:34 UTC] sander@php.net
Does this problem still occur with 4.0.6, the latest RC (http://download.php.net/~zeev/php-4.1.0RC3.tar.gz) or the latest CVS?
 [2001-12-18 07:13 UTC] sander@php.net
No feedback. Closing.
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Mon Jan 25 18:01:23 2021 UTC