Cannot open MDB file in .exe

swimitup · March 15, 2023, 1:48am

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: odbc:Driver={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.

oldteacher · March 17, 2023, 5:52pm

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.

swimitup · March 19, 2023, 3:09am

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.