Hello everyone,
I am having the difficult time trying to figure out how to detract an
max user license when my script tries to connect to our Pervasive
database through an ODBC connector. I am looking for a way to ignore
the error if one arise and continue on with the code.
Here is what I have so far
if($conn = odbc_connect($aei_db, $user, $pass))
{
$sql_open_jobs = "select distinct jh.part, jh.date_due,
jd.job, jd.seq, jd.employee, jd.description, jd.Date_Sequence
from v_job_header jh, v_job_detail jd
where jd.job = jh.job and
jh.date_closed='1900-01-01' and jd.job not like '%IND%' and jd.suffix =
jh.suffix";
$rs_open_jobs = odbc_exec($conn, $sql_open_jobs);
echo $refresh_message;
}
else
{
if(!($conn = odbc_connect($aei_db, $user, $pass)))
{
$refresh_message = "This page has not been refreshed
since: " . date("h:i");
echo $refresh_message;
$have_license = false;
}
}
Thanks in advance
Richard Sharp
Database Administrator
PH: 316-942-8604 ext 108
Tenderness is what love looks like in private, Justice is what love
looks like in public - Cornel West
I am what I am because of who we all are - Ubuntu
