#19624 [Bgs->Opn]: win2k/odbc/networked drives

ID: 19624 User updated by: tracer@netrox.net Reported By: tracer@netrox.net -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] derick@php.net 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] tracer@netrox.net 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