Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
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: 21416
33
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