• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 420
  • Last Modified:

Really confused about ODBC in 64bits Win7


I'm sure that I am overlooking something pretty obvious but can't figure it out.

I have to setup a named machine DSN on a new win 7 64 machine (french UI but I guess it's irrelevant).

I have tried to migrate most of our apps to DSN-less connections but I still have an Access 2007 line of business software that requires a named DSN to an Oracle database.

I have checked that I can connect to said database from the 32bits version of Access without problems.

However I can't seem to define a named DSN on that machine - the only driver I get proposed is for SQL server:

ODBC admin
Apparently if I go to ODBC admin it is the 32 bits version which is launched (from process explorer).

From Access I have a very different dialog:

Connect to datasource - Access
Not sure what's going on here. Any help / advise most welcome
Alexandre Takacs
Alexandre Takacs
2 Solutions
Check this:
May be it is your case. What version of odbccad32 are you starting?
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Yes, it's really confusing in that there are two version of the 32 bit ODBC manager and you need to use the right one.  The one you want is in the %WINDOWS%\SystemWOW64 folder.

Your not the first either<g>  

This question pops up at least once a week.

- since Access is a 32bit application. you will need to use the 32bit ODBC Admin (Odbcad32.exe) which is in the %systemdrive%\Windows\SysWoW64 folder to setup your DSN. then use that DSN name in your application.

- don't use the ODBC Admin in the Windows Control Panel, its for 64bit application/driver.
Alexandre TakacsCTOAuthor Commented:
Thanks all for your responses - problem solved. I was aware of the issue but my confusion was caused by the fact that the 64 bit ODBC manager is actually called odbcad32.exe ... So I thought I was executing the 32 bit admin. All clear now !

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now