I'm having difficulties with an ODBC connection to an Oracle 11g database. I'm running Windows XP with Office 2010. I've installed the Oracle ODBC drivers and successfully created a DSN to the Oracle database. We've been able to ping the database, connect via SQL Plus and even link tables from within an Access 2002-2003 database. When I attempt to link from an Access 2007 database I get the error -
*****
ODBC--call failed.
Specified driver could not be loaded due to system error 127 (Oracle in OraClient11g_home1). (#160)
*****
I can't find anything to tell me what driver is not being loaded or what system error is occurring.
I would appreciate any help as I really don't want to downgrade these databases in order to make the connections work.