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 =

            $rs_open_jobs = odbc_exec($conn, $sql_open_jobs);


            echo $refresh_message;




            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



Reply via email to