Error handling a max license issue

["Richard Sharp" <RSharp@xxxxxxxxxxxxxxx>]

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