Re: Bug #6275 Updated: ODBC_Prepare/ODBC_Execute fails with parameters

I agree with kowalsky, it is probably a limitation in the access odbc driver. Sorry for confusing everyone (including myself!). Regards, John > > > ATTENTION! Do NOT reply to this email! > To reply, use the web interface found at > http://bugs.php.net/?id=6275&edit=2 > > > ID: 6275 > Updated by: sander > Reported By: jlim@natsoft.com.my > 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] 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-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:\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")); > } > > > > > ------------------------------------------------------------------------ > > --- "Stressed spelled backwards is desserts." jlim@natsoft.com.my NATSOFT MALAYSIA (60)3-7806 1216 My personal PHP website: http://php.weblogs.com/ My company's PHP website: http://phplens.com/