Where can I download and how to install ODBC for Oracle - Windows 7

I need ODBC drivers in Windows 7 (and 8) so I can connect to an Oracle DB from MS Access.

I've spent the last hour searching and found lots of people frustrated with this but no answers.

I can't even find a download link. The only place I found on the Oracle site said in the ReadMe file that it supports XP and lower.

It's 64 bit os, but only 32 bit MS Office.

So, I'm stuck and confused.

Please help!
KapriceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamMandenoCommented:
I googled the following:
download oracle odbc driver for windows 7

and I got many hits, the first one of which is:
http://www.oracle.com/technetwork/database/windows/downloads/index-096177.html

It looks like what you want.  I think if you have 32-bit Access you should also install the 32-bit driver.

Graham Mandeno [Access MVP since 1996]
0
KapriceAuthor Commented:
Yeah, that's one of the links I found in my own searching. But, note the date of those files (2006!).

And, the readme from the download says,

You can install the ODBC client software on any of the following systems:

o Windows XP
o Windows Server 2003
o Windows 2000
o Windows NT X86
o Windows 98

The Oracle ODBC Driver provides support for ODBC connections
from Windows XP, Windows 2000, Windows NT, and Windows 98 systems to
Oracle databases.

So, I was reluctant to install it until someone confirmed it's the right one.
0
GrahamMandenoCommented:
There is quite a good blog on the subject with step-by-step instructions here:
https://itkbs.wordpress.com/2014/07/28/how-to-install-odbc-driver-for-oracle-in-windows-7/
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

KapriceAuthor Commented:
Holy Smokes! What a complicated process. I don't suppose you've tried it and can verify it works?

There's only one comment on the blog: "It didn't work,"
0
GrahamMandenoCommented:
No, sorry - I don't have any databases with Oracle back-ends.

I would be surprised if you need to define environment variables.

It appears that you will need instantclient-basic-nt-xx.x.x.x.zip and  instantclient-odbc-nt-xx.x.x.x.zip.  I guess you choose the version number to match your Oracle database.

-- Graham
0
johnsoneSenior Oracle DBACommented:
I would recommend the Instant Client.  It can be downloaded here -> http://www.oracle.com/technetwork/topics/winsoft-085727.html

To use ODBC, you need to download 2 things.  The first is Basic and the second is ODBC.  Check through the README files, but the installation is typically just a matter of unzipping the files.  ODBC may have an install to it as well, but they are pretty easy to do.

It doesn't sound like you need a full client, but if you want that, you can download that here -> http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

For the full client, you need to download the full enterprise install and then when you run the installer, you select client only.  It is a more involved install and it doesn't sound like you need all those features.

Since your version of Access if 32 bit, then  you need to download the 32 bit versions of the client.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
>> I guess you choose the version number to match your Oracle database.

Not necessary.  I would choose the latest and greatest.  It will connect to all currently supported database versions and many unsupported database versions.
0
johnsoneSenior Oracle DBACommented:
One catch to the latest and greatest version.  There doesn't appear to be a 32 bit full client version of 12 available for download, there is only a 64-bit version listed.
0
KapriceAuthor Commented:
Thanks, everyone.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.