#21082 [Com]: odbc_primarykeys Access

From: Date: Sun, 05 Oct 2003 20:58:51 +0000
Subject: #21082 [Com]: odbc_primarykeys Access
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-48575@lists.php.net to get a copy of this message 
 ID:               21082
 Comment by:       dlaroche at nobug dot lu
 Reported By:      jcdavid at libertysurf dot fr
 Status:           Bogus
 Bug Type:         ODBC related
 Operating System: Win XP
 PHP Version:      4.2.0
 New Comment:

Well I'm using PHP 4.3.3. an it seems that the bug haven't been fixed
yet.

The OS I'm using is Windows XP with Apache 2 (but I don't think that
the version of apache is so important for this bug).

I've tried it with Access 97 to 2002, nothing worked. The
odbc_statistics doesn't work aswell.

Would be nice if you could patch this, as it would be very usefull for
me and also for other people.


Previous Comments:
------------------------------------------------------------------------

[2002-12-18 13:55:27] kalowsky@php.net

Thank you for taking the time to report a problem with PHP.
Unfortunately you are not using a current version of PHP -- 
the problem might already be fixed. Please download a new
PHP version from http://www.php.net/downloads.php

If you are able to reproduce the bug with one of the latest
versions of PHP, please change the PHP version on this bug report
to the version you tested and change the status back to "Open".
Again, thank you for your continued support of PHP.

I believe this was fixed...

------------------------------------------------------------------------

[2002-12-18 13:28:40] jcdavid at libertysurf dot fr

I cant get the primarykeys, php always return "Warning: SQL error: ,
SQL state 00000 in SQLPrimaryKeys"

<?php
$dsn = "gerhisto"; 
$usr = "";
$pwd = ""; 
$db = "gerhisto";
$con = odbc_connect ($dsn,$usr,$pwd) or die ("Echec de connexion sur
ODBC : $dsn");
$res = odbc_tables ($con) or die ("Pas de tables dans $db de ODBC :
$dsn");
$i=0;
while (odbc_fetch_row ($res)) {
	if (odbc_result ($res, 4)=="TABLE") {
		  $qualifiers[$i] = odbc_result ($res, 1);
		  $owners[$i] = odbc_result ($res, 2);
		  $tables[$i] = odbc_result ($res, 3);
		  $types[$i] = odbc_result ($res, 4);
		  $remarks[$i] = odbc_result ($res, 5);
		  echo "$i, Table : $tables[$i], Qualifier : $qualifiers[$i], Owner :
$owners[$i], Type : $types[$i], Remarks : $remarks[$i]<br>";
		  $i++;
	}
}
echo "<br>$i tables<br><br>";
for ($j=0;$j<$i;$j++) {
  echo "Clefs Primaires de ".$tables[$j];
  $res = odbc_primarykeys ($con, $qualifiers[$j], $owners[$j],
$tables[$j]);
  if ($res)
    odbc_result_all ($res);
  else
  	// ==> Warning: SQL error: , SQL state 00000 in SQLPrimaryKeys 
    echo ("Error : ".odbc_error ($con).": ".odbc_errormsg
($con)."<BR>");
}
odbc_close ($con);
?>

------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=21082&edit=1

Thread (5 messages)

« previous php.bugs (#48575) next »