ID: 6275
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: ODBC related
Assigned To: kalowsky
Comments:
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.
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]
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]
