32 bit ODBC drivers on 64 bit Windows

It’s been a while since I had to use an ODBC driver.  Today I learned…

That when you install a 32 bit ODBC driver on a 64 bit Windows but it doesn’t show up in the Data Sources admin tool because this tool displays only 64 bit drivers.

That you can manage a 32 bit ODBC driver on a 64 bit Windows using the 32 bit Data Sources admin tool located here:
C:\Windows\SysWOW64\odbcad32.exe

That 64 bit software can’t use 32 bit ODBC drivers.

That 32 bit software installed on a 64 bit Windows can use 32 bit ODBC drivers.

AchievementODBC

Bookmark and Share

5 Comments

  • Except when the 32-bit driver has not been made to run on 64-bit machines, the prime example being vfpoledb.dll (the VFP9 oledb driver). As you point out, it can be installed (with the regsvr32.exe that is present in the SysWow64 directory); and viewed with odbcadm32 in SysWow64; but that's where it all stops.

    Sybase will be releasing a 64-bit version of their Advantage obdc driver this summer, capable of accessing VFP tables. Their ado.net driver already handles both 32-bit and 64-bit scenarios.

  • I unregistered the database from the x64 ODBC and registered it using the x86 ODBC driver. My applications seem to working fine using the x86 ODBC driver on our Windows 2008 X64 server.

  • Hello Guys,
    I have a similar problem with and application that import from VFP 8.0 to SQL Server.
    In x86 works fine, but I have problems in win 2008 server x64.
    Don M:
    Please, Which version of the ODBC for VisualFox Pro did you use?
    How I can unregistered the X64 version and register for X86 odbc?
    Thanks in advance,
    Danteco

  • Hi All,

    I had a simular problem running windows XP on a 64 bit system. I could not create an ODBC to my access database until I found this page and ran the odbcad32.exe now all my links work. I am running Office 2003 by the way. How do I unregister the x64 ODBC and replace it with the x86 odbc driver?

    Kirby

  • Hi Guys,

    I had a problem trying to get my odbc to work on my Dell T7500 until I found this web site. My question is how do I unregister the X64 version and register the X86 odbc version so it will work with my access databases. I am using Access 2003 and I don't see my company moving to the latest version this year.

    Thanks

    Kirby

Comments have been disabled for this content.