Hello,

some days ago I asked help on this list because I have to develop and
test on Linux/Apache some PHP pages that will have to run on on an
IIS/NT box. On the real server the pages must manage a MS Access
database via ODBC (this mixed setup cannot be changed: explanations in
the original message).

Now, first of all I would like to thank everybody for their help, and
ask about the following solutions. I know they're awkward, but I must
make it work ASAP (and performance is not a problem, even the real
server is a relatively low traffic site)

1) I could convert the Access DB to Mysql and then write PHP pages
which use a wrapper layer for all standard db management calls (as
explained in the PHP Developer's Cookbook, chapter 6). Then the only
change needed before uploading on the server would be the include of
the file with the wrapper functions. In this way I could test all the
DB management part of PHP on Linux/MySQL and be sure that it will work
on NT/Access also.

2) I could recreate a Mysql database with the same tables on Linux,
and access it indirectly from PHP using the ODBC/MySQL interface. In
this way the I would be using ODBC in both cases. I guess this would
give bet
ter performance, as the wrapper layer is not needed anymore,
right?

What do you think about:

        which solution is easier to set up?
        which gives more guarantees that the PHP code will work
        transparently?
        did anybody do it before?
        any other issue (performance, stability, whatever)


                TIA,
                        mweb





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to