We help IT Professionals succeed at work.

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

Rita Byrne
Rita Byrne asked
on
Medium Priority
5,586 Views
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.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
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.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
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
CERTIFIED EXPERT
Top Expert 2015
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Top Expert 2011

Commented:
- 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
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

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

mlmcc
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.

OR

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.