jwhite68 Posted June 15, 2007 Share Posted June 15, 2007 Does anyone know if its possible to connect to an MS Access database, via PHP on a Linux O/S. I had mistakenly assumed that I could achieve this with the ADODB database abstraction layer, since it lists Access as a supported database. However, I now understand that this is limited to PHP running on a Windows Server, due to some library/libraries required. Any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/55707-connecting-to-ms-access-database-from-php-on-linux/ Share on other sites More sharing options...
spooke2k Posted June 15, 2007 Share Posted June 15, 2007 hi can i ask why you are using access rather than a mysql server as it would make more sense and you can find thousands of easy and brilliant tutorials on how to access the mysql server including set up etc. Spooke2k Quote Link to comment https://forums.phpfreaks.com/topic/55707-connecting-to-ms-access-database-from-php-on-linux/#findComment-275241 Share on other sites More sharing options...
jwhite68 Posted June 15, 2007 Author Share Posted June 15, 2007 Sure. Its because my application needs to be able to support a particular industry, where the 'customers' may have their data stored in many formats. Since Access is still a popular choice of database for this industry, I cannot force the customers to migrate to MySQL (or other) just because of my own technical challenges, you see. So, its really down to a customer driven demand. Quote Link to comment https://forums.phpfreaks.com/topic/55707-connecting-to-ms-access-database-from-php-on-linux/#findComment-275243 Share on other sites More sharing options...
spooke2k Posted June 15, 2007 Share Posted June 15, 2007 http://bryanmills.net:8086/archives/2003/11/microsoft-access-database-using-linux-and-php/ i googled it and think this might help Spooke2k Quote Link to comment https://forums.phpfreaks.com/topic/55707-connecting-to-ms-access-database-from-php-on-linux/#findComment-275244 Share on other sites More sharing options...
jwhite68 Posted June 17, 2007 Author Share Posted June 17, 2007 Thanks. That would be good if my hosting provider supported UnixODBC - however, they say they dont. Does anyone else have any experience or ideas on this? Quote Link to comment https://forums.phpfreaks.com/topic/55707-connecting-to-ms-access-database-from-php-on-linux/#findComment-276171 Share on other sites More sharing options...
trq Posted June 17, 2007 Share Posted June 17, 2007 Sorry, but without UnixODBC your out of luck. Access databases are simply not meant to be used on systems other than windows. Quote Link to comment https://forums.phpfreaks.com/topic/55707-connecting-to-ms-access-database-from-php-on-linux/#findComment-276176 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.