Guest User

Untitled

a guest
Nov 23rd, 2018
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. sudo apt install php7.2-odbc
  2. ...
  3. Setting up php7.2-odbc (7.2.10-0ubuntu0.18.04.1) ...
  4. Creating config file /etc/php/7.2/mods-available/odbc.ini with new version
  5. Creating config file /etc/php/7.2/mods-available/pdo_odbc.ini with new version
  6. Processing triggers for libapache2-mod-php7.2 (7.2.10-0ubuntu0.18.04.1)
  7.  
  8. php -i | grep PDO
  9. PDO
  10. PDO support => enabled
  11. PDO drivers => mysql, odbc, pgsql, sqlite
  12. PDO Driver for MySQL => enabled
  13. PDO_ODBC
  14. PDO Driver for ODBC (unixODBC) => enabled
  15. PDO Driver for PostgreSQL => enabled
  16. PDO Driver for SQLite 3.x => enabled
  17.  
  18. $db_username = ''; //username
  19. $db_password = ''; //password
  20. // path to database file
  21. $database_path = "/home/jcobban/FamilyTree/Cobban.mdb";
  22. // check file exist before we proceed
  23. if (!file_exists($database_path)) {
  24. die("Access database file not found !");
  25. }
  26. //create a new PDO object
  27. $database = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=$database_path; Uid=$db_username; Pwd=$db_password;");
  28. $sql = "SELECT * FROM tableName";
  29. $result = $database->query($sql);
  30. while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
  31. print_r($row);
  32. }
  33.  
  34. Fatal error: Uncaught PDOException: SQLSTATE[01000] SQLDriverConnect: 0 [unixODBC][Driver Manager]Can't open lib 'Microsoft Access Driver (*.mdb, *.accdb)' : file not found in /home/jcobban/public_html/testAccess.php:14 Stack trace: #0 /home/jcobban/public_html/testAccess.php(14): PDO->__construct('odbc:DRIVER={Mi...') #1 {main} thrown in /home/jcobban/public_html/testAccess.php on line 14
  35.  
  36. sudo apt-get install odbc-mdbtools
  37. sudo apt-get install unixodbc-dev
Add Comment
Please, Sign In to add comment