Connecting to access 97 using php on Linux

Question

You clever people can probably set me straight on this without me wasting any more time trawling the internet so here goes....

Our company still uses access 97 mdb files for some legacy applications and I would love to be able to connect and interrogate these databases using php / apache running on a Linux box. Upgrading the databases is not an option so I have to use them in the current format.

So the question is, is this even possible and if so, how would I go about it?

You can convert an Access db to MySQL if you no longer need the Access project, and only want to use PHP moving forwards. Or to answer your original question, you can use ODBC with PHP to connect to your Access db. — Danny Beckett
– Danny Beckett, Commented Mar 21, 2013 at 10:59
PHP's ODBC driver should do it, but bear in mind the constraints of using an Access DB. If this PHP system is going to need to support multiple concurrent users, an Access DB isn't designed to be able to cope with that; there's a strong probability you'll get database corruption as a result. — SDC
– SDC, Commented Mar 21, 2013 at 11:23

Sathishkumar · Accepted Answer · 2013-03-21 11:17:04Z

2

User Below Code :

$dbName = $_SERVER["DOCUMENT_ROOT"] . "products\\products.mdb";
if (!file_exists($dbName)) {
    die("Could not find database file.");
}
$db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$dbName; Uid=; Pwd=;");

You should enable PDO & ODBC extenstions in PHP.INI file.

answered Mar 21, 2013 at 11:17

Sathishkumar

3,4144 gold badges22 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

solo1977 Over a year ago

Thanks people. Its given me a starter. I'm using mdbtools with unixODBC. Once the information was in the odbc.ini and odbcinst.ini files I was able to link to the mdb file using: $conn=odbc_connect('dbname','',''); I think I may have uncovered a 'bug' with the odbc_exec but I will post this elsewhere. Thanks for your help and I will mark this as answered shortly.

solo1977 · Accepted Answer · 2013-04-02 09:01:46Z

0

Thanks people. Its given me a starter. I'm using mdbtools with unixODBC. Once the information was in the odbc.ini and odbcinst.ini files I was able to link to the mdb file using: $conn=odbc_connect('dbname','',''); I think I may have uncovered a 'bug' with the odbc_exec but I will post this elsewhere. Thanks for your help and I will mark this as answered shortly.

answered Apr 2, 2013 at 9:01

solo1977

3934 silver badges14 bronze badges

Collectives™ on Stack Overflow

Connecting to access 97 using php on Linux

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related