Wednesday, 6 November 2019

PHP Problem connecting php and .mdb with pdo-odbc

I have php program that requires MS Access, so I had to use odbc. Locally, using DSN it was working fine:

$db = new PDO("odbc:MyDSN");

I also have no problem when I put the php and odbc at the server and access it remotely:

$db = new PDO("odbc:DRIVER=MDBTools; DBQ=Data.mdb;");

But I can't afford to use it for some reason. I want to put php on the server together with the database but I want to place odbc (or the odbc driver) on the client, something like this:

$db = new PDO("odbc:{127.0.0.1\foo\bar\odbc.ini}; DBQ=Data.mdb;");

I can't seems to work with it for a while. I'm using Ubuntu 64bit as server, and Windows 7 as client

UPDATE 1: I found a way to do it, but it needs to modify the PHP itself (Classes,structure,etc.) I hope someone can help me to get alternative solutions

UPDATE 2: Another solution, but requires third party software.



from PHP Problem connecting php and .mdb with pdo-odbc

No comments:

Post a Comment