ID: 6275
Updated by: kalowsky
Old-Status: Open
Status: Analyzed
Bug Type: ODBC related
Assigned To: kalowsky

Previous Comments:

[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]

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:Inetpubwwwrootphpadodbindex.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 
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"));


ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to