Friday, September 6, 2013

Using ODBC 32-bit on 64-bit Operating System

Which ODBC driver should we install on 64-bit machine using Windows Server 2008 R2, Windows Server 2012, Windows 7, or Windows 8? It would depend. When I installed MySQL ODBC 64-bit driver on Windows 8.1 Preview, it worked when I added a new DSN. But, it did not work when Microsoft Access 2007 application made ODBC call to MySQL server.

What wrong? It took me couple hours to figure out. Microsoft Access 2007 may not work with other 64-bit driver or program yet. Installed MySQL ODBC 32-bit solve the problem.

On Windows 8.1, there are two ODBC Administrors under Control Panel – Administrative Tools. One for ODBC Datasources 32-bit and one for ODBC Datasources 64-bit. On Windows Server 2008 R2, there is only one reference to ODBC Administrator. This is 64-bit. Where is 32-bit? To add or manage DSN for ODBC 32-bit, you need to call program odbcad32.exe in C:\Windows\SysWOW64\

Hope this help.

1 comment:

  1. This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
    healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
    Solutions for all Industries,
    Getting your applications talking is the key to better business processes,
    Rapid web services solutions for real business problems,
    Web-based Corporate Document Management System,
    Outsourcing Solution,
    Financial and Operations Business Intelligence Solution,

    Our address:
    2002 Timberloch Place, Suite 200
    The Woodlands, TX 77380
    281-364-1799

    prologic-corp

    ReplyDelete