We help IT Professionals succeed at work.

Connecting Win7, 64 bit to Oracle

851 Views
Last Modified: 2012-05-11
I know this will be odd, but we need to connect some new machines to an old database. Our new machines are Win7, 64 bit, Professional. We have a couple old Access databases which link to data on our Oracle server. HP-UX Oracle version 8.0.6. (Stop laughing)

Here is where I am at. I have managed to install the 8.0.6 client on these machines as well as 32 bit Win7 Pro. The 32 bit machines work without a hitch. On the 64 bit machines, I can successfully set up the DSN and retrieve data using the Oracle ODBC test app. I can also run Custom VB apps which use OLE to link to the Oracle data with success.

When I try and retrieve data in the Access database I receive an error 6413 Driver's SQLSetConnectAttr failed IM006.

I can not use the newer Oracle drivers as they will not connect to this older version of the database server.

Any thoughts are appreciated.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
8.0?  I'm not laughing... more like cringing.

There is likely going to have to be some smoke and mirrors.  I'm thinking an intermediate database.

Either a older version of Access that can connect/link to 8.0 then link the new access to the other database

Or, maybe a 9i Oracle database that will link to the 8.0.  I don't think 10g will link to 8.0 but it might.

Author

Commented:
I have tried versions of Access from 97 to 10, with no different results from any of them since they are all using the same Oracle ODBC driver.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
I was thinking more along the lines of create an older version of access using an older verions of driver.  I guess now that I type that out, it doesn't make sense since it would have to be on a different machine and probably couldn't be accessed from the local machine...

I'm sure other Experts will be around shortly and have more sound ideas...
Top Expert 2009

Commented:
You can actually use Oracle 9i driver to downconnect to 8, if that helps. I also seem to recall that 10.0 driver worked against it as well. 10.2 does not.

The point is you are not limited to 8.0 driver.

On the 64-bit machines, check that you didn't install them into "Program Files (x86)" as the old drivers do not like parentheses in the Oracle home path name.

Author

Commented:
Will moving to the 9i client driver do anything for me? On our XP machines we have played some with the later drivers and did not see any change that warranted moving to them.

The client was not installed into the (x86) directory.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
The issue is you need something the version of Access knows how to deal with.  This version also needs to know how to talk to an Oracle 8.0 database.

We're thinking the 9i drivers and possible the 10.0 drivers might bridge that gap.

I was just trying to figure out a way to use the older versions without actually installing them on the new machines.

Author

Commented:
I tested another configuration on a second machine. I used the Oracle 9i client. It still only throws an error on the ODBC connection from within Access. The error is ORA-12154 with the exact same description of the error.

The ODBC test and OLE connection continue to function without problems.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
An ORA-12154 is a tnsnames.ora configuration issue not really a version issue.

You need to make sure every version of Oracle installed has a valid tnsnames.ora file or you have one common one and set an environment variable called TNS_ADMIN pointing the the folder where you put it.

Author

Commented:
I've verified that the tnsnames.ora files are functional. I can get data through the SQL*Plus app as well.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
I guess I should also add: 64Bit Windows comes with two different versions of the ODBC administrator.  The 32Bit one needs to be manually executed from the SysWoW64 folder.

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

Author

Commented:
On each machine I have only the single version of Oracle installed.

I have become very familiar with the location of the ODBC 32 bit admin. (LOL)
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Maybe mrjoltcola will be around later and can add to what you are now seeing with the ora-12154.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

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