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.
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
http://forums.oracle.com/forums/thread.jspa?threadID=1010383&tstart=0