Using the FairCom ODBC Drivers, PHP, MysSQL
Migrated the ODBC Drivers from an NT Workstation to a 2000 Profesional Box. Worked great on the NT Workstation, but on the 2000 Box I keep getting an error when trying to ODBC data on a mapped drive!?
Anyone had this problem?!
If I move the data to the physical drive of the 2000 box it works fine, once I setup the ODBC driver to the mapped drive (F🙂 I get the following
Warning: SQL error: [FairCom][FairCom ODBC Driver][FairCom File Library]No such table or object., SQL state S0002 in SQLExecDirect in e:\apache\htdocs\soc\restricted\socaddnewpt.php on line 49
Here is the stripped down version of my php
<?
$odbc_dsn = "rx30";
$odbc_userid = "";
$odbc_password = "";
$ulastname = (convert_uc($lastname));
$ufirstname = (convert_uc($firstname));
$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);
PLEASE, PLEASE HELP!
