Reserved error (-7732) when attempting to open Oracle table via Access

We are trying to open an Oracle table on a machine that is running Windows 7 64 bit, Office 2010 64 bit, and has the 64 bit Oracle client 100201 installed. In Excel we can go to Data, From Other Sources, From Microsoft Query/ODBC, Select the database, login with our credentials, and the data is imported. However, when attempting this from Access via External Data, ODBC, Import, Machine Data Source, "Reserved error (-7732); there is no message for this error" appears. Since the connection works via Excel, maybe there is a setting that needs changed in Access? We have installed the latest Office and Windows patches on this machine. Thanks.
stsadminAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

devindCommented:
Check the solution suggested by user " Jam The Man" at
http://forums.oracle.com/forums/thread.jspa?threadID=1010383&tstart=0
0
stsadminAuthor Commented:
I read this previously as well, but it appears his issue was he couldn't connect at all and was trying to set up a connection via Excel. I can connect via Excel, but not Access. I don't think this solution would apply to my issue?
0
slightwv (䄆 Netminder) Commented:
I have to assume Excel and Access are using the same DSN thus the same Oracle ODBC drivers.

You are likely hitting some obscure bug.  Do you have to use a 10g Oracle driver or can you move to an 11g one?
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
stsadminAuthor Commented:
Sorry, late in getting back on this. We tried using the 11g version and it worked from another machine. I haven't had a chance to try on the machine in question because the user is on vacation. However, I'm guessing that will fix it as well.
0
MingtenanceSystemCommented:
Hi I exactly had this situation before with Oracle 11g (11.1.0.6.0) installed. Problem fixed after installed ver 11.2.0.1.0. Make sure use 11.2 or later.
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.