I'm trying to access an ODBC connection in PHP via PDO_ODBC. This is my code:
$db = new PDO('odbc:MyDSN', '', '');
SQLSTATE[IM002] SQLConnect: 0 [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified
There are actually two separate Microsoft ODBC Administrator apps, one for 32-bit and one for 64.
As this KB article explains:
The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.
Nope, not a typo -- the 32-bit version is in the
SysWoW64 folder and the 64-bit is in the
System32 folder. (o_O)
I was running a 64-bit web server which was checking the 64-bit ODBC library for the DSN, whereas I had it in the 32-bit. Downgrading the server did the trick.