ID: 19624
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Bogus
+Status: Open
Bug Type: ODBC related
Operating System: win2k
PHP Version: 4.2.3
New Comment:
If the data is on a local drive the php returns the querry correctly.
If the data is on the networked drive F: then php returns
Warning: SQL error: [FairCom][FairCom ODBC Driver][FairCom File
Library]No such table or object., SQL state S0002 in SQLExecDirect in
Here is the pertinent PHP info
(NOT: I am using FAIRCOM drivers to acess c-tree created db's
www.faircom.com)
<?
odbc_dsn = "rx30";
$odbc_userid = "";
$odbc_password = "";
$connection = odbc_connect($odbc_dsn, $odbc_userid, $odbc_password);
$query = "SELECT patient.NameLast, patient.NameFirst,
patient.NameMiddle, patient.Patnbr, patient.EmpLink, patient.DOB,
patient.LicNbr
FROM patient
WHERE patient.NameLast LIKE '$ulastname%'
AND patient.NameFirst LIKE '$ufirstname%'";
$result = odbc_exec($connection, $query);
?>
Previous Comments:
------------------------------------------------------------------------
[2002-09-26 15:16:15] [EMAIL PROTECTED]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
------------------------------------------------------------------------
[2002-09-26 15:15:34] [EMAIL PROTECTED]
Apache 1.3/PHP 4.2.2/Win2k(prof) SP3
PHP will not open tables via odbc on MAPPED drives or NETWORKED drives
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=19624&edit=1
