• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5061
  • Last Modified:

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

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.
0
itwex
Asked:
itwex
1 Solution
 
slightwv (䄆 Netminder) 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.
0
 
slightwv (䄆 Netminder) Commented:
Just remembered something:  is crystal 32 or 64?

I remember reading something about a 32bit odbc dsn configuration that you need to run.
0
 
QlemoC++ DeveloperCommented:
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.
0
 
OP_ZaharinCommented:
- 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.
0
 
mlmccCommented:
The newest version of Crystal is 32 or 64-bit.  Most versions in use are 32-bit only.

mlmcc
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now