title: odbc_connect problem with mdbtools and unixodbc
body: <p>I would like to acccess a mdb file in a windows machine (windows server 2003) from a linux machine (centos 6.10) </p>
  
  <p>Im using mdbtools and unixodbc </p>
  
  <p>so far what i did</p>
  
  <pre><code>odbc.ini
  [mydatabase]
  Driver = MDBTools
  Description = Microsoft Access Try DB
  Servername = localhost
  Database =/mnt/example.mdb
  UserName =Admin
  Password =
  port = 5432
  
  odbcinst.ini
  [MDBTools]
  Description = MDBTools Driver
  Driver64 = /usr/lib64/libmdbodbc.so.0
  Setup64  = /usr/lib64/libmdbodbc.so.0
  FileUsage   = 1
  UsageCount  = 1
  </code></pre>
  
  <p>i check the connection using isql in terminal</p>
  
  <pre><code>isql -v mydatabase
  </code></pre>
  
  <p>and it returns connected
  i can query the database successfully
  by using query like this</p>
  
  <pre><code>select * from units
  </code></pre>
  
  <p>right now i want to connect the access database using php</p>
  
  <pre><code>test4.php
  &lt;?php
  error_reporting(E_ALL); ini_set('display_errors', 1);
  
  $myDB = odbc_connect("mydatabase","Admin","");
  
  $query = "select * from units";
  $result = odbc_exec($myDB, $query);
  $report = odbc_fetch_row($result);
  echo odbc_result($result, 1);
  
  odbc_close($myDB);
  
  ?&gt;
  </code></pre>
  
  <p>i received this error </p>
  
  <pre><code>Warning: odbc_connect(): SQL error: Failed to fetch error message, SQL state HY000 in SQLConnect in /var/www/test/test4.php on line 6
  
  Warning: odbc_exec() expects parameter 1 to be resource, boolean given in /var/www/test/test4.php on line 11
  
  Warning: odbc_fetch_row() expects parameter 1 to be resource, null given in /var/www/test/test4.php on line 12
  
  Warning: odbc_result() expects parameter 1 to be resource, null given in /var/www/test/test4.php on line 13
  
  Warning: odbc_close() expects parameter 1 to be resource, boolean given in /var/www/test/test4.php on line 15
  </code></pre>
  
  <p>im currently using </p>
  
  <pre><code>PHP Version 7.2.28
  mySQL Version   5.7.29
  </code></pre>