I've got a problem of obtaining access to .mdb file (MS-Access db) on Ubuntu. I need full access(read and write too).
Originally project was built on Windows using odbc (and everything has worked well). But when I moved it on linux-server appeared problems.
At the moment PHP-extensions for work with odbc are installed. But I can't find any free ODBC-driver for work with Access. I've tried to use MDB Tools but seems it works only for reading.
Maybe somebody can suggest any solution? Usage of some another DB is not appropriate, because my boss is against it.
Thanks for any help.
我有一个问题是在Ubuntu上获得对.mdb文件(MS-Access数据库)的访问权限。我需要完全访问权限(读取和写入)。最初项目是使用odbc在Windows上构建的(一切都运行良好)。但是当我把它移到linux-server上时就出现了问题。目前安装了与odbc一起使用的PHP扩展。但我找不到任何免费的ODBC驱动程序与Access一起工作。我试过使用MDB工具,但似乎只适用于阅读。也许有人可以建议任何解决方案?使用另一个DB是不合适的,因为我的老板反对它。谢谢你的帮助。
3 个解决方案
#1
3
By installing mdbtools from the Linux repository you can work with mdb in Linux. mdbtools is a free package that can solve your problem.
通过从Linux存储库安装mdbtools,您可以在Linux中使用mdb。 mdbtools是一个免费的软件包,可以解决您的问题。
Take a look at this tutorial
看一下本教程
#2
1
Thanks everybody for your help. Finally we decided to use another DB. My answer on this question - it's impossible(if you need to write to DB) to use Access DB on linux based only on free solutions. If you need only read you can use MDB tools with PDO. If you're ready to pay you can try EasySoft solutions.
谢谢大家的帮助。最后我们决定使用另一个DB。我对这个问题的回答 - 不可能(如果你需要写入DB)在Linux上使用Access DB只能基于免费解决方案。如果只需阅读,可以将MDB工具与PDO一起使用。如果您准备付款,可以试试EasySoft解决方案。
#3
0
You can read/write MS Access files using ADODB, the PHP libraries for ADODB can be found here: http://adodb.sourceforge.net/
您可以使用ADODB读/写MS Access文件,ADODB的PHP库可以在这里找到:http://adodb.sourceforge.net/
#1
3
By installing mdbtools from the Linux repository you can work with mdb in Linux. mdbtools is a free package that can solve your problem.
通过从Linux存储库安装mdbtools,您可以在Linux中使用mdb。 mdbtools是一个免费的软件包,可以解决您的问题。
Take a look at this tutorial
看一下本教程
#2
1
Thanks everybody for your help. Finally we decided to use another DB. My answer on this question - it's impossible(if you need to write to DB) to use Access DB on linux based only on free solutions. If you need only read you can use MDB tools with PDO. If you're ready to pay you can try EasySoft solutions.
谢谢大家的帮助。最后我们决定使用另一个DB。我对这个问题的回答 - 不可能(如果你需要写入DB)在Linux上使用Access DB只能基于免费解决方案。如果只需阅读,可以将MDB工具与PDO一起使用。如果您准备付款,可以试试EasySoft解决方案。
#3
0
You can read/write MS Access files using ADODB, the PHP libraries for ADODB can be found here: http://adodb.sourceforge.net/
您可以使用ADODB读/写MS Access文件,ADODB的PHP库可以在这里找到:http://adodb.sourceforge.net/