ID: 6275
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: ODBC related
Assigned To: kalowsky
Comments:
starting to look into windows problems, only problem is I have only win98, so the
winNT and 2k won't likely happen...
Previous Comments:
---------------------------------------------------------------------------
[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: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
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"));
}
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=6275&edit=2
--
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]
