Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Where Did My 32-bit ODBC Drivers Go?!

DZone's Guide to

Where Did My 32-bit ODBC Drivers Go?!

Sometimes we have to deal with using legacy technology in newer systems. In this case, how do we access old 32-bit ODBC drivers from newer 64-bit Windows instances?

· Integration Zone ·
Free Resource

The new Gartner Critical Capabilities report explains how APIs and microservices enable digital leaders to deliver better B2B, open banking and mobile projects.

These days, 64-bit machines running true, 64-bit operating systems are rather commonplace. Windows is no exception.

Speaking of the Windows world, when it comes to data connections, the operating system continues to hold on and use the age-old, tried-and-tested Open Database Connectivity standard (or, ODBC).

This means that there may be times when you, the trusty developer, need to access legacy data sources that haven't been supported since the original Celebrity Jeopardy sketches on Saturday Night Live first appeared.

Image title

An actual category.

(Courtesy: buzzfeed.com)

You're lucky enough to have the actual installer for the 32-bit ODBC driver (since doing it by hand would be a nightmare), so you run it and everything looks to go all right, surprisingly.

So you navigate yourself to the ODBC administration tool and notice your driver isn't listed.

Oh, well, that makes sense since we actually want the 32-bit ODBC administration tool, so you open that instead.

It still is not there.

Uh oh.

Well, as it turns out, both of those tools point to the same binary which exist in the Windows/system32 directory, where, contrary to the name, the 64-bit executables exist.

So what do you do?

Fortunately, most of your favorite 32-bit files can be found in Windows/SysWOW64.  Within that directory, you will find odbcad32.exe which will allow you to now see your 32-bit ODBC drivers and manage any related DSNs.  Awesome!

Hopefully this tip will save some of you some headache in the future as we continue to have to support legacy data sources on newer, 64-bit Windows machines.

The new Gartner Critical Capabilities for Full Lifecycle API Management report shows how CA Technologies helps digital leaders with their B2B, open banking, and mobile initiatives. Get your copy from CA Technologies.

Topics:
windows ,32-bit ,64-bit ,odbc ,drivers ,database ,connectivity

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}