ID: 6275 Updated by: sander Reported By: [EMAIL PROTECTED] Old Status: Analyzed Status: Feedback Bug Type: ODBC related Operating System: Windows 98 PHP Version: 4.0.1pl2 Assigned To: kalowsky New Comment:
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? Previous Comments: ------------------------------------------------------------------------ [2001-04-01 19:36:34] [EMAIL PROTECTED] 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-03-23 17:01:42] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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")); } ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=6275&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
