RE: [PHP] Access to MYSQL via ODBC?
| From: | Jon Haworth | Date: | Tue, 13 Nov 2001 16:08:43 +0000 |
| Subject: | RE: [PHP] Access to MYSQL via ODBC? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-74459@lists.php.net to get a copy of this message | ||
> apart from performance issues, is it possible in PHP to read/write a
> MYSQL DB not directly, but via ODBC? The reason (as states in my other
> message "MS ACCESS on Linux") is that it would make possible to test on
> Linux PHP code that would eventually manage (wit xero or minimal changes)
> an MS access on NT/IIS.
While the theory behind this is sound, a quick caveat: Access' SQL is
waaaaaaaaaaaaaaaaaaaaay out in left field somewhere, and you might find you
need to do considerable tweaking to get the same results out of Access &
MySQL.
You might want to consider some sort of db abstraction layer to make the
transition a bit easier - it's more work up front, but the benefits are many
:-)
Cheers
Jon
**********************************************************************
'The information included in this Email is of a confidential nature and is
intended only for the addressee. If you are not the intended addressee,
any disclosure, copying or distribution by you is prohibited and may be
unlawful. Disclosure to any party other than the addressee, whether
inadvertent or otherwise is not intended to waive privilege or confidentiality'
**********************************************************************