[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1514
  • Last Modified:

Help with Oracle 11g ODBC on Win Server 2008 R2

Hello,
I'm setting up software on a server to connect to Oracle 11g running on AIX 6.1.  The server is Win Server 2008 R2 64 bit.  I downloaded and sucessfully installed Oracle client 64bit for windows.  I can connect with SQL plus and I can configure a system dns name to the Oracle database on the AIX server. I created the Oracle_Home variable on the server.   For testing I'm trying to connect MS Access 2003.  Access does not show the system odbc.  Any Ideas what I should do next?
0
jrbledsoe001
Asked:
jrbledsoe001
  • 3
  • 3
1 Solution
 
slightwv (䄆 Netminder) Commented:
The bit versions need to match.  If Access is 32Bit, you need the 32Bit Oracle drivers (I suggest the Instant Client and ODBC add-on available on the same Oracle download page).

Also there are two versions of ODBC administrator.  The 32Bit version is in a different folder:

http://support.microsoft.com/kb/942976

0
 
jrbledsoe001Author Commented:
Hello slightwv!  You have helped me in the past.  I'll take a look again at the downloads page and update my post with the results.
0
 
slightwv (䄆 Netminder) Commented:
The instant client can be found here:
http://www.oracle.com/technetwork/topics/winsoft-085727.html

You will need two pieces:

Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications

instantclient-basic-nt-11.2.0.2.0.zip(50,325,016 bytes)




Instant Client Package - ODBC: Additional libraries for enabling ODBC applications

instantclient-odbc-nt-11.2.0.2.0.zip(739,591 bytes)

0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
jrbledsoe001Author Commented:
For some reason I had to install the 32bit oracle client to get the oracle driver to show up for MS access.  It's working.  Thanks big time for your help!!!
0
 
jrbledsoe001Author Commented:
thank you
0
 
slightwv (䄆 Netminder) Commented:
Glad to help and that it is working.

Not sure why the Instant Client didn't work.
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.

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