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:
FOUND A FIX
If apache is running as service, the above will not work, run it in a
dos window under the user thats currently logged in, and it will....Go
figure. Guess it's an apache prob
Previous Comments:
------------------------------------------------------------------------
[2002-09-26 15:52:36] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[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
