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 clients)
- 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 Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help

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.