#13604 [Com]: odbc_primarykeys with Access

ID: 13604 Comment by: joost at cnoc dot nl Reported By: phperror at gustl dot at Status: No Feedback Bug Type: ODBC related Operating System: W98, W98SE PHP Version: 4.0.6 New Comment: This is not so strange, since MS Access doesn't support the odbc SQLPrimaryKeys-api call. So this will never work as long as Microsoft doesn't fix this. Previous Comments: ------------------------------------------------------------------------ [2007-05-26 12:16:27] ahmedmatah at yahoo dot com fffff ------------------------------------------------------------------------ [2006-08-11 03:45:57] kaspernj at gmail dot com Hi, I have the exact same problem with the latest CVS of PHP 5.1, Access-database saved with Access 2003, Windows XP 32bit with SP2 and all the latest updates (11-08-2006). The warning I get is this: Warning: odbc_primarykeys(): SQL error: , SQL state 00000 in SQLPrimaryKeys in D:\phpprogs\knj_sqladmin\DBConn.php on line 357 ...with the following code: <? $f_gpk = odbc_primarykeys($this->conn, "", "", $tablename); ?> $this->conn is being used many times, before it fails on "odbc_primarykeys()", so I have established a connection to the Access database - I am sure. It is possible to read the tables data. odbc_columns() works as espected. odbc_tables() works as espected. ------------------------------------------------------------------------ [2003-07-12 03:04:09] sa_kelkar at yahoo dot com I have same problem with odbc_primarykeys when i am using with the DB2. Please guide me my code is <?php //include 'conn.inc'; $usernm="db2admin"; $pwd="nic20pao03lx#"; $schemaname="db2admin."; $conn=odbc_connect("PAOLX",$usernm,$pwd); $m=odbc_primarykeys($conn,"SYSIBM","SYSIBM","TB_DDO_ELECTRICITY"); echo $m; ?> ------------------------------------------------------------------------ [2002-09-09 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2002-08-05 20:38:19] kalowsky@php.net Using the latest CVS I cannot get your sample code to work at all. It seems the $tables is never populated on my end. Any chance you can post a sample schema, or see if this is still happening? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/13604 -- Edit this bug report at http://bugs.php.net/?id=13604&edit=1