Cannot open MDB file in .exe

A bit challenging. MDB connection works fine using xampp. EXEOutput’s PHP configuration is 7.4 with obviously php_pdo_odbc.dll extension activated.

When compiled, .exe triggers an exception:

SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Database: odbcriver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\ProgramData\Meet Manager DEMO\Meets\database.MDB;Uid=Admin; Pwd=;

In the same machine, MS Access is fully installed.

Out of ideas.

I had similar issue (was not using exeout) and it was due to 32/64bit drivers. Had to look back at notes and this got me back on track:


I bring this up to remind exeout is 32bit.

Hello,

thanks for the tip, indeed php’s 7.4 version on ExeOutput is 32bits, while the php’s 7.4 xampp version is 64bits. very likely to be the problem… will test.