We have several programs that utilize ODBC to an Infomrix database on a SCO box. In addition to several PHP scripts, we have a few Windows programs that access the datasource. While looking through the oplrqb.log file, I notice that each Windows program passes the "application name" to ODBC. FOr example, we have a Windows label program called EasyLabel, which access the ODBC datasource, and the log entry looks like this:
09:53:03 connect params: domain=Informix 5 db=maindb serveropts= readonly=1 09:53:03 connectopts= user=webuser opsys=win32 machine=192.168.200.38 application=EASY
When my PHP scripts access the db, I get this:
09:48:55 connect params: domain=Informix 5 db=maindb serveropts= readonly=1 09:48:55 connectopts= user=webuser opsys=unix machine=linux application=
As you can see, the PHP script does not send anything for the application name. Is there a way I can have PHP send the application name through an environment variable or something? I need to change some mappings on the ODBC server that would allow write access to the db, when the PHP script sends a certain application name.