php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jlim at natsoft dot com dot my
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2024 The PHP Group
All rights reserved. 		Last updated: Tue Oct 15 07:01:27 2024 UTC