From: [EMAIL PROTECTED]
Operating system: RedHat 6.2
PHP version: 4.0.4pl1
PHP Bug Type: ODBC related
Bug description: ODBC - odbc_exec does not seem to work with an Access db
I am unable to use PHP/Openlink ODBC to get specific rows based on my SELECT statement
form a MS Access 97 db. I can use PHP/Openlink just fine while accessing an Informix
db hosted on a SCO box. I can also use Perl/DBI:DBD:ODBC to get the rows I need from
this Access db, so I'm guessing this is a PHP bug. Here is a snipet of the code I use:
putenv( "ODBCINI=/usr/local/openlink/bin/odbc.ini" );
putenv( "ODBCHOME=/usr/local/openlink" );
putenv( "ODBCINST=/usr/local/openlink/bin/odbcinst.ini");
$conn = odbc_connect("DSN=ink","","", SQL_CUR_USE_ODBC);
$sql = "SELECT DISTINCT * FROM ComponentUse WHERE Code = 'CX145' ";
$cur = odbc_exec($conn, $sql);
// This section of code displayes the tables in the db fine.
$tablelist = odbc_tables($conn);
while (odbc_fetch_row($tablelist)) {
echo odbc_result_all($tablelist);
}
// This section of code does not work - dies with "Driver not capable"
while (odbc_fetch_row($cur)){
$code = odbc_result($cur, "code");
printf ("Code: $code\n");
}
odbc_close($conn);
The code will display the table list just fine, but I get the following error from the
odbc_exec statement:
Warning: SQL error: [OpenLink][ODBC][Driver]Driver not capable, SQL state S1C00 in
SQLExecDirect in
/home/httpd/html/ink/dispenser/comp_use.php on line 23
Like I said, I can use Perl/DBD just fine to get the rows I want with that select
statement, so this must be a PHP bug?
Thanks for any help. I really would like to write this application in PHP, since I'm
not too proficient in Perl.
--
Edit Bug report at: http://bugs.php.net/?id=9869&edit=1
--
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]
