From: dlaroche at nobug dot lu Operating system: Windows XP Professional PHP version: 4.3.3 PHP Bug Type: ODBC related Bug description: odbc_primarykeys error
Description: ------------ I'm trying to write a script to convert tables from a Microsoft Access (version from 97 to 2002) to MySQL. The first step is that I just want the structure of the tables, so I need several functions from odbc. But for the primary keys, the function odbc_primarykeys doesn't work. I read that I can get the key information of a table using the odbc_statistics function but this function doesn't work aswell. Reproduce code: --------------- $resAccessPrimaryKeyList = odbc_primarykeys($resAccessConnection, "", "", "tblManif"); echo(odbc_result_all($resAccessPrimaryKeyList)); Expected result: ---------------- don't know the result but I want to get a list with the primary keys of the table. Actual result: -------------- Warning: odbc_primarykeys(): SQL error: , SQL state 00000 in SQLPrimaryKeys in E:\htdocs\ltam\odbc.php on line 65 Warning: odbc_result_all(): supplied argument is not a valid ODBC result resource in E:\htdocs\ltam\odbc.php on line 66 -- Edit bug report at http://bugs.php.net/?id=25757&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25757&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25757&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=25757&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=25757&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=25757&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=25757&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=25757&r=support Expected behavior: http://bugs.php.net/fix.php?id=25757&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=25757&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=25757&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=25757&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25757&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=25757&r=dst IIS Stability: http://bugs.php.net/fix.php?id=25757&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=25757&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=25757&r=float
