We help IT Professionals succeed at work.

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

Rita Byrne
Rita Byrne asked
Medium Priority
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.
Watch Question

Most Valuable Expert 2012
Distinguished Expert 2019

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.
Most Valuable Expert 2012
Distinguished Expert 2019

Just remembered something:  is crystal 32 or 64?

I remember reading something about a 32bit odbc dsn configuration that you need to run.
"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Unlock this solution and get a sample of our free trial.
(No credit card required)
Top Expert 2011

- 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.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.