AnsweredAssumed Answered

MacOSX - "SQLSTATE[01000] SQLDriverConnect: 0 [unixODBC][Driver Manager]Can't open lib 'FileMaker ODBC' : file not found"

Question asked by devapp on Jul 12, 2016
Latest reply on Jul 12, 2016 by taylorsharpe

I'm trying to use PDO to connect to a File Maker pro database locally. I have compiled the PHP PDO ODBC driver, and its installed per the attached screen shot.

 

I've also installed File Maker locally, enabled ODBC and enabled an ODBC connection for it System wide.

 

When I try to connect to the datasource which I've set up "Tasks" I receive the following:

    "errors": "SQLSTATE[01000] SQLDriverConnect: 0 [unixODBC][Driver Manager]Can't open lib 'FileMaker ODBC' : file not found", 

 

$dsn = 'odbc:Driver={FileMaker ODBC};Server=localhost;Database=Tasks;';
$pdo = new \PDO($dsn, "odbc", "odbc");
dd($pdo);

 

I have also tried:

$this->conn= new \PDO('odbc:Tasks', '', '');

 

I'm at a loss to why it won't connect. I have installed the ODBC driver too from File Maker Pro.

Outcomes