Hi,
We have an MS Access application that connects to ORACLE to pull the data. We are using the ODBC based DSN to connect to the Oracle. As of now we are trying to configure the DSN using the ODBC driver 'Oracle in OraClient11g_Home1'. We configured the TSN successfully in the TSNNAMES.ORA in the ORACLE HOME directory. The TSN name is appearing in the DSN configuration window. But when I tried to Test the Connection it is failing. the ODBC error is thrown with error number M004. Anyone please help in resolving the issue. We have configured the ORACLE_HOME and TSN_ADMIN in the environment variables. Earliest help is appreciated.
Regards,
KALYAN