How could i connect to MS Access DB in Linux Server, is it possible with PHP

Discussion in 'PHP' started by Syam, Mar 9, 2007.

0
  1. #1
    I was trying to connect to MS Access DB using PHP in a Linux Server. It is unfortunate that it is not working. can anybody help me?

    Hopefully :confused:
     
    Syam, Mar 9, 2007 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Here's a brief overview:
    http://www.phpbuilder.com/columns/siddarth20000228.php3

    I recently did it with MSSQL, Linux and PHP and is was a difficult complicated process. In the end we did get the database connected, but the functionality was so reduced that we ended up switching the site to a windows server, and installed php on it.

    Anyway the overview is that you need an ODBC driver that is compatable with MS Access. Freetds is what we used for MSSQL, and it may be what you need for MS Access as well. Also you have to compile php with php_odbc, and make sure you have c, c++ compilers installed in your linux machine. After everything is installed, is it just a matter of configuring the odbc driver to connect to the database, and configuring php to use the odbc driver, normally using the odbc_ functions.
     
    jestep, Mar 9, 2007 IP
  3. prudentialwebdev

    prudentialwebdev Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Or you could export your access in any number of ways,
    and import it into mysql postgre or whatever format youre using on linux.
     
    prudentialwebdev, Mar 9, 2007 IP