Posted by paul on 09/09/05 12:51

On Thu, 08 Sep 2005 21:25:23 -0700, jsw_nz wrote:

> Helo, my first post here....
>
> I am trying to run an agent application that converts and imports two
> tables from MS Access into mySql.
> (Intelligent Converters - Access2mySql)
> I have run similar scripts to do mysql dumps using the system function.
> Not sure if the paths included in the parameters are correct:
>
> <?php
> function import_data() {
> $sourceFile = "C:\Program Files\Intelligent converters\myAccessDB.mdb";
> $tableFile = "C:\Program Files\Intelligent Converters\whichTables.txt";
> system("/Program Files/Intelligent Converters/A2SAGENT.EXE
> --dest=st_staff --src=$sourceFile --tab_file=$tableFile --mode=1");
> }
> import_data();
> ?>
>
> This syntax works fine in command line prompt, but somehow it is not
> working when called from php. I have tried two versionn of this (one
> using user/pass - not shown) and the one above.
>
> Any pointers on running this, and getting results.
>
> Cheers,
> John

I see two possible causes for errors here:

1) to call the program you do not use a drive letter, are you sure the
program is executed?

2) space in path name. Try escaping the spaces in the path names. Space
might be handled differently from a script than from command line.

Paul

[Back to original message]