How to configure Oracle to be able to query a MS Access database (.mdb) that is lcoated in the remote server?
I tried using configuring odbc and HS, at last am getting error
"ORA-02019: connection description for remote database not found"
I Am using Oracle XE 11g 11.2.0.2.0 and Ms Access 2007
Thanks in advance
Jerin
Have you setup the appropriate database link ? eg
SQL> select * from tab@qweqwe;
select * from tab@qweqwe
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
I get that error because "qweqwe" is a non-existent database link.
For HS connectivity you need:
1) listener and tnsnames correctly setup.
There are examples in $ORACLE_HOME/hs/admin
2) an ODBC source that the tnsname will connect to
3) a database link to point to the tnsname entry
Tim Hall has a nice post on this
https://oracle-base.com/articles/misc/heterogeneous-services-generic-connectivity Hope this helps.