ID: 19624
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Bogus
Bug Type: ODBC related
Operating System: win2k
PHP Version: 4.2.3
New Comment:
I'm tempted to say this isn't a PHP bug but a Faircom bug. As ODBC
doesn't care about local FS issues, its concern is mapping DSN's to
data sources. From that error you've pointed to it sounds like the
Faircom drivers are not noticing it. There is nothing that PHP can do
about this.
Marking as bogus unless you can prove otherwise.
Previous Comments:
------------------------------------------------------------------------
[2002-09-26 15:21:33] [EMAIL PROTECTED]
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);
?>
------------------------------------------------------------------------
[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
