File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure 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
  • 0
  • 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
Pie
Posts: 20196
26
MySQL Database
  • 0
  • 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
  • 0
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic