Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
zalak thakkar
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 22185
38
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!