[PHP-DEV] PHP 4.0 Bug #6275 Updated: ODBC_Prepare/ODBC_Execute fails with parameters
ID: 6275
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Status: Analyzed
Bug Type: ODBC related
Assigned To: kalowsky
Comments:
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?
Previous Comments:
---
[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: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 executebr";
$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=6275edit=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]
[PHP-DEV] PHP 4.0 Bug #6275 Updated: ODBC_Prepare/ODBC_Execute fails with parameters
ID: 6275
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Status: Analyzed
Bug Type: ODBC related
Assigned To: kalowsky
Comments:
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.
Previous Comments:
---
[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: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 executebr";
$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=6275edit=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]
[PHP-DEV] PHP 4.0 Bug #6275 Updated: ODBC_Prepare/ODBC_Execute fails with parameters
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 executebr";
$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=6275edit=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]
[PHP-DEV] PHP 4.0 Bug #6275 Updated: ODBC_Prepare/ODBC_Execute fails with parameters
ID: 6275
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Analyzed
Bug Type: ODBC related
Assigned To: kalowsky
Comments:
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 executebr";
$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=6275edit=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]
