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: [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")); > } > > > > > ------------------------------------------------------------------------ > > --- "Stressed spelled backwards is desserts." [EMAIL PROTECTED] NATSOFT MALAYSIA (60)3-7806 1216 My personal PHP website: http://php.weblogs.com/ My company's PHP website: http://phplens.com/ -- 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]
