The installation command should provide a way to select the desired packages without forcing the end user to first check to see which version of PHP is running on the system. This is an issue with everything that needs to be installed to extend PHP.
Note that the package to install is not particularly obvious, since all of the web pages I found specified to install either php5-odbc or php7.0-odbc, depending upon how many years ago they were posted, and while it may be obvious to the package maintainers that the driver packages must match the installed version of PHP that is not obvious to the end user who just wants the "right" package installed. Ĭreating config file /etc/php/7.2/mods-available/odbc.ini with new versionĬreating config file /etc/php/7.2/mods-available/pdo_odbc.ini with new version Some sites suggest using ODBC as a workaround, so I installed the package php7.2-odbc as follows: sudo apt install php7.2-odbc I do not have a license to run Windows on any of my computers so I cannot test an implementation that runs only on Windows. The exact numeric key values would not be the same in both databases. Also like most beginners the DBA used server-managed or "auto-increment" primary keys for almost all of the tables.
The file is then uploaded to the server where its contents are read to initialize or update the server database, but the conversion is not straightforward because the structure of the server SQL database is not identical to that of the Access database, mostly because the DBA who designed this particular Access database assumed that there would never be a requirement for simultaneous access to the database by multiple users.
The user interface has to be to identify the file containing the customer's existing data. mdb file to a MySQL/MariaDB/Postgres/SQLite/. In particular the page does not list "Microsoft Access", or "JET", or ".mdb", or ".accdb" in the description for any of the listed drivers.įor this application it would be excessively cumbersome to demand that the end-users use something like mdbtools to convert the.
Most of the pages only discuss how to do this on a Windows system, where naturally the PHP installation comes with support already installed for the standard Microsoft database engines. I searched dozens of web sites and could not find a straightforward way to achieve this. mdb (Microsoft Access© (JET) file) copied from a Windows system on Linux, specifically Ubuntu 18.04.