Database Link to MS Access
I am having a few minor setup issues in getting a database link correctly established from MS Access to Oracle 10g XE. Here is what I have done thus far:
1. Set up an ODBC System DSN called MFC_LOCAL to the Access database using the MS Access driver pointed at the *.mdb file.
2. Updated the listener.ora with the following entry:
(SID_DESC =
(SID_NAME = mfc_local)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = hsodbc)
)
3. Updated the tnsnames.ora with the following entry:
mfc_local =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ***hostname***)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = mfc_local)
(SERVER = DEDICATED)
)
(HS = OK)
)
4. Added the following lines to the %ORACLE_HOME%\hs\admin\initmfc_local.ORA
HS_FDS_CONNECT_INFO=mfc_local
HS_FDS_TRACE_LEVEL=off
4.I have created the link in the 10g XE using the following syntax:
CREATE DATABASE LINK link_mfc_local USING 'mfc_local';
When I attempt to test the database link, the following error message is reported:
Error Testing Database Link.
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC] ORA-02063: preceding 2 lines from MFC_LOCAL
I know I have misconfigured something(s), but I am not sure which steps or where to go from here. Any help would be greatly appreciated.
(EDIT: Modified wrong file. Changed to use HS\Admin\initmfc_local.ora. )
Message was edited by:
SWestenzweig
Message was edited by:
SWestenzweig