Access is the backend for a proprietary front end. I just checked with
the company and they can't understand why anybody would want to change
the program(!). In any case, they won't allow it.
So, I'm stuck with the ODBC call from the Win computer sending data to
the mysql db on the linux computer.
How can I get a web page called after the ODBC call? Am I stuck with a
cron job on the linux box?
Bastien Koert wrote:
You should be able to open a web page from access (might need to write
a module) and call a page that would then run your script
Bastien
From: bill <bill@xxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: running program after insert w/MySQL 4.1
Date: Fri, 07 Jul 2006 15:11:07 -0400
I have an Access database connecting via ODBC to a local MySQL
machine and doing inserts. It does these inserts throughout the day.
After each insert, I need a PHP program run.
Alas, MySQL 4.1 doesn't do triggers, etc., and upgrading to 5.x looks
non-trivial.
What else can I do? Is there any way to trigger something via the
ODBC connection?
A cron job?
I'm open to suggestions.
kind regards,
bill
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
