Really confused about ODBC in 64bits Win7

Hello

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
LVL 1
Alexandre TakacsCTOAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
als315Commented:
Check this:
http://support.microsoft.com/kb/942976/en-us
May be it is your case. What version of odbccad32 are you starting?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.

Jim.
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
OP_ZaharinCommented:
- 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.
0
 
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 !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.