Help with PDO ODBC connection to an MDB database file

Hosting Support
1

Dear InfinityFree support,
I’m trying to connect to an MDB database file through PDO odbc connection with PHP.
I’ve tried the following connection strings:

$db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$dbName; Uid=; Pwd=;");

and

$db = new PDO("odbc:DRIVER=MDBTools; DBQ=$dbName; Uid=; Pwd=;");

But there’s the following error:

Fatal error: Uncaught PDOException: could not find driver in /home/xxxxxxxxxxxxxxxxxx:28 Stack trace: #0 /home/xxxxxxxxxxxxxxxxxx(28): PDO->__construct('odbc:DRIVER={Mi...') #1 /home/xxxxxxxxxxxxxxxxxx(19): include('/home/vol8_7/ep...') #2 {main} thrown in /home/xxxxxxxxxxxxxxxxxx on line 28

I had this same error on my localhost and I solved it by uncommenting this line in php.ini file:

extension=php_pdo_odbc.dll

I’ve tried to alter PHP.ini file from control panel but there’s no options to add extensions.

How can I solve it?

Waiting for your reply
Thanks

2

The ODBC driver for PDO is not enabled on our servers. I’m not sure whether it was disabled for a specific reason or just that nobody bothered to enable it. I don’t know any application which uses ODBC, everyone just uses the native MySQL or SQLite drivers. You’re the first person ever to ask about it.

And since InfinityFree (like any web hosting) is a shared hosting service, you cannot fully customize the PHP configuration or add modules not provided by the server.