Learn more about SQL Server tools

solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips

   Got a SQL tip?
            We want to know!

How to install 64 bit ODBC driver on SQL Server 2008 R2 64 bit version.

Asked 5/2/2012 7:45:38 AM by Ajit


I have windows server 2008 R2 standard edition with SQL Server 2008 R2 standard edition. I have install odbc driver with this command “c:\Windows\SysWOW64\odbcad32.exe”

Now the version is


SQL Server                                                 6.01.7601.17514

SQL Server Native client 10.0                    2009.100.2500.00




Now I am not able to understand which version of these drivers are 32 bit or 64 bit.

And if these are 32 bit driver then how can I reinstall 64 bit driver.


Answered 5/2/2012 10:19:46 AM by sreekanth bandarla (0) vote answer is useful vote answer is NOT useful

Ajit - I think You are good with your Drivers. You can check for Odbcad32.exe in both "C:\Windows\SysWoW64" and "C:\Windows\System32"  folders.

FYI, http://support.microsoft.com/kb/942976

It clearly says...

A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):

  • The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
  • The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

Answered 5/2/2012 11:29:12 PM by Ajit (0) vote answer is useful vote answer is NOT useful

Thanks for reply Sreekanth. I have already checked & Odbcad32.exe exist in both folders. As I already mentioned that I install drivers from %systemdrive%\Windows\SysWoW64 folder. So the odbc driver is 32 bit version. But now when I try to install from %systemdrive%\Windows\System32 folder. I am not able to install 64 bit driver. Now How can I uninstall 32 bit & install 64 bit driver.

This is the main issue.

Thanks in Advance.

Answered 6/16/2012 3:21:09 AM by Petar (0) vote answer is useful vote answer is NOT useful
Thanks!Yeah, servers are deifintely the big place where this comes into play. Funny, I think an x64 SharePoint box was the first time I ran into it, too.

Answered 9/18/2012 11:39:37 AM by Neshan (-6) vote answer is useful vote answer is NOT useful

Hi. I am running the following and would like to know if there are any issues with it.

SQL Server     6.01.7601.17514

SQL Server Native Client 10.0    2007.100.5500.00




Post an Answer

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email   Notify for updates
*Enter Code refresh code

Sponsor Information

Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | today's tip | first timer?
Some names and products listed are the registered trademarks of their respective owners.