Installing Oracle Client on Windows7 (64 bit) for ODBC Connection

Posted on 2011-04-26
Last Modified: 2012-06-27
I need to install an Oracle Client on a Windows7 OS in order to talk to an Oracle database via Crystal Reports.

I downloaded & installed the Oracle 11g Client - Win3211gR2_client (had tried the 64 bit previously). I set up the Service Name in Net Manager & tested the connection & it works perfectly but I cannot get the ODBC connection to work.

I set up the System DSN but cannot get beyond selecting Oracle & get the message "The setup routines for the Oracle in OraClient_11g_home1 ODBC driver could not be loaded due to system error 193".

Advise appreciated.
Question by:itwex
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    I believe the bits need to match.  64bit odbc needs 64bit drivers.

    When you said you previously tried the 64bot, what was the problem?

    I also suggest the Instant Client for just ODBC.  Can't remember if there is a 64bit version.  On mobile right now and can't check.
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Just remembered something:  is crystal 32 or 64?

    I remember reading something about a 32bit odbc dsn configuration that you need to run.
    LVL 67

    Accepted Solution

    Yes. For 32bit ODBC driver, you need to use the 32bit ODBC Administrator, which is
    %SystemRoot%\SysWow64\odbcad32.exe .
    The one you call via Start Menu or Run is 64bit.
    LVL 23

    Expert Comment

    - slightwv is right. if the crystal report is a 32bit application, then you need to setup 32Bit dsn instead. if you are setting up the ODBC from the admin in the Control Panel, you are actually setting up using the 64bit driver.

    - when working with a 32bit client on a 64 bit OS, you need to use the 32bit ODBC admin in C:\windows\syswow64\odbcad32.exe rather than the one in control panel. if you didn't find the directory you need to download the 32bit Oracle client and install in on the Windows 7 machine.
    LVL 100

    Expert Comment

    The newest version of Crystal is 32 or 64-bit.  Most versions in use are 32-bit only.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    The viewer will learn how to back up with the free utility from runtime software, DriveImageXML using Windows 7. Download DriveImageXML from Open folder where it was saved: Start installation by double clicking the install scrip…
    The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

    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

    20 Experts available now in Live!

    Get 1:1 Help Now