Really confused about ODBC in 64bits Win7

Posted on 2012-09-10
Last Modified: 2012-09-10

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
Question by:atak2983
    LVL 39

    Assisted Solution

    Check this:
    May be it is your case. What version of odbccad32 are you starting?
    LVL 56

    Accepted Solution

    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.

    LVL 23

    Expert Comment

    - 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.
    LVL 1

    Author Comment

    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 !

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now