nixCraft

Hello,
I want to know is it possible integrate access database with php in linux server.
here with i have attached my requirement:
- A Linux server configured to run Apache/PHP
- The same server has a directory in which an Access database is stored. (This directory is samba-mounted and used from Windows client
- I want a PHP page created that accesses this Access database. May be just read a table and show on the page.

Your thoughts will be greatly appreciated...Thanks in advance...

Thanks,
ephdia.

Yes it is possible, you need to use ODBC under UNIX / Linux see following urls for more info. From php.net:

unixODBC
PHP: Database issues - Manual

Under Windows you can use Apache+php along with ODBC provided by Windows itself.

__________________
Vivek | My personal blog
Linux Evangelist
Play hard stay cool

Thanks a lot for your reply... But i am getting "Warning: odbc_exec() [function.odbc-exec]: SQL error: [unixODBC]Couldn't parse SQL , SQL state 08001 in SQLExecDirect in /home/xxx/access.php on line 42

any idea about this error...

Hi,
I have followed this link bryanmills.net » Blog Archive » Microsoft Access Database using Linux and PHP
and integrated MS-Access with php on linux server.Now i can read the MS-Access database but couldn't edit or modify that.
Is that any more driver have to install for getting full access on MS-Access database?

Thanks,
ephdia

My days of developing Cold Fusion + MS Access lead me to a deep distrust of MS Access as a web back-end even for a few users. Please consider reversing role on MS Access: make it the client for a mysql database and then as your application gets popular, you'll scale safely, and the Access users will still have a familiar interface for managing their data.