aspose file tools*
The moose likes PHP and the fly likes SQL error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Languages » PHP
Bookmark "SQL error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch " Watch "SQL error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch " New topic
Author

SQL error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch

zalak thakkar
Ranch Hand

Joined: Sep 09, 2013
Posts: 33
Hello everyone,

i have a problem while connecting PHP application with Microsoft Access database. It shows me following error:


odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application, SQL state IM014 in SQLConnect in C:\wamp\www\Class_PHP\odbc_accessEx.php on line 7


Can any one please help me to resolve this?

Thank you.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18570
    
    8

That means that PHP is expecting to use a 32-bit database and you asked it to use a database which was 64-bit. Or vice versa.
zalak thakkar
Ranch Hand

Joined: Sep 09, 2013
Posts: 33
Thank you Paul, For your quick reply.

But i have 32 bit odbc database and i have to access it through %windir%\sysWOW64\odbcad32.exe ..

And I can handle connection with PHPmyadmin but not with Access, Please help me.

Thank you
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch