I am trying to link identical tables in Oracle DB and MS Access and I followed steps in this article.
I did step 1 - 6 and I got 'OK' message for tnsping testing.
From MS Access side, this is what I did.
I got Select Data Source windows
Select "File Data Source' tab
From 'Create New Data Source' pop up, I selected Oracle in OraDb10g_home1, gave name and clicked finish button, but got this error message.
'A connection could not be made using the file data source parameter entered'
If I choose 'Machine Data source' tab and clicked 'new' button and selected OraDb10g_home1, the I got this error msg.
'The setup routines for the Oracle in OraDb10g_home1 ODBC driver could not be loaded due to system error code 998.
what is wrong?